Problem in creating a view in IS

[former_member280200]

Hi,

Has anyone seen this kind of behaviour in IS when creating a view?

We created a view based off a flat file (comma delimited text file with only 25 rows), the view validated and saved without any errors, however when we try to view data off that view we keep getting this error:

"Dataservices execution failed for (14.0) 05-09-12 12:36:38 (E) (9028:8876) FIL-080124: |Data flow vviewdf2726_2012_05_09_12_35_49_0_1_mds5798|Transform EID_2_IS_VIEW_RDR_2726_11__AL_ReadFileMT_Process The bad row limit for file is met. The limit specified is .. Error (14.0) 05-09-12 12:36:38 (E) (9028:8876) FIL-080124: |Data flow vviewdf2726_2012_05_09_12_35_49_0_1_mds5798|Transform EID_2_IS_VIEW_RDR_2726_11__AL_ReadFileMT_Process The bad row limit for file is met. The limit specified is . (COR-10690)"

I double check the file - the file format is valid (no carriage return or leading/trailing spaces) and there are only 25 rows in the file.  Any idea what could be causing this error?

TIA.

Lynne

[Former Member]

I have encountered this error too, and am a little lost where to go for help with it.

step 1 - Within Information Steward CMC - I create an application connection to SAP which validates and test connects fine.

step 2 - I have created a link within Information Steward to an SAP table, and I can view data and profile data with no problems.

step 3a -

However, when I import a view (that works in other tiers) to the Information Steward that is a single table view (for the table that works in step 2 above) - I get the following error.

step 3b

I even tested creating a view directly within Information Steward (remove import step) for a single column within the table 

When I profile through the view ( or just try to view data through the view) I get the following :

[I] 2013-09-26 10:01:31.452 Processed [1] of [1] sub tasks. (TSK-10047)
[I] 2013-09-26 10:01:31.459 Summary of task [ColumnProfiling 2013.09.26 10:00:51] with [1] subtask(s) executed. (TSK-10005)
[I] 2013-09-26 10:01:31.466 [1] Subtask(s) executed with errors. (TSK-10007)
[I] 2013-09-26 10:01:31.483 Subtask [run id=1] Table SAP Finance.VW_CM_Bill_To_Customer_KNA1: Import of ATL failed for: #__AW_Repository_Version 14.0.0.0000;
#__AW_Product_Version 14.0.0.0000;
#__AW_ATL_Locale eng_us.utf-8;

CREATE DATABASE DATASTORE ICCDS_62 SET ("name"=ICCDS_62,"cdc_enabled"=no,"application_type"=R/3,"database_type" = R/3,"sap_host_name" = <host>sap_client" = 800,"sap_system_number" = 00,"user" = <UNAME>, "password" = <PW>,

"locale_codepage" = <default>,"sap_language" = EN - English,"abap_execution_mode" = execute_preloaded,"abap_batch_mode" = yes,"abap_server_dir" = ',"generated_abap_dir" = ',"security_profile" = ',"DB_connection_retry_count" = 3,"DB_retry_interval" = 10000,"loader_file_location" = no_location,"import_unknown_type" = yes,"unknown_type_size" = 255,"enable_data_transfer" = no); :: Error com.sap.icc.dataservices.api.DSAPIException: Dataservices execution failed for . Error  (COR-10690) (TSK-10008)
[I] 2013-09-26 10:01:31.652 Task process finished with errors. Status is set to failed. (TSK-10027)
[I] 2013-09-26 10:01:31.659 Utility processing ended.

Because this is working in other Tiers - I am really confused as to what to do to fix this problem - any help appreciated.

NOTE : I changed the <host> , <UNAME> and <PW> in the message for hopefully obvious reasons.

[Former Member]

Lynne,

I know this thread existed from a year ago now but I encountered this error this morning and thought it would be useful for others in the future

The problem in this instance is the schema that Information Steward reads. It couldnt read the different datatyopes that existed in the schema on my dataset and cam up with the error above. In my case it had a mix of varchar, int and decimals. Once i converted the fields to varchar (realise this won't always be acceptable) it worked perfectly. Hope this helps

Regards

Matt

[former_member182007]

Lynne,

I have not come across this kind of error before but would recommand if you can go inside the CMC ( Central management console)  and in this Information Steward .. here you can see some sections where you can manage all the numbers of source limit and time limits, probablly this way you can set this up.

second also make sure when you are trying to view data you do not have any task running or stopping.

please let us know the findings.

Hope it helps

thx

deep