1 Reply Latest reply: Mar 11, 2013 8:27 AM by Deepak K Gupta RSS

File Connection to XLS file from BOIS 4.1

Tejaswini Patil
Currently Being Moderated

Hello Experts,

 

Environment : IPS, BO IS 4.1 Oracle system database. Source database is XLS File extract taken from system.

 

We have requirement of Data profiling on file extract taken from system.

Data Insight supports only txt, csv file connections. We did conversion of xls file to txt file with data as semicolon separated also we defined code page settings as UTF-8

 

File connection from CMC is OK and Filed Data Rules connection is on oracle database.

 

I designed IS NULL rule ( very simple one) for my txt file however its giving errors as below:

 

 

[I] 2013-03-09 09:00:22.441 Started execution on 2013-03-09 09:00:21. (COR-10014)

[C] 2013-03-09 09:00:22.526 License validation done successfully.

[I] 2013-03-09 09:00:22.526 Utility processing starts.

[I] 2013-03-09 09:00:22.528 Started Task process view_tas [task ID=18]. (TSK-10025)

[I] 2013-03-09 09:00:22.539 Initializing Subtask queue with information from Task. (TSK-10040)

[I] 2013-03-09 09:00:22.794 Started Subtask process [subtask id=621], processing table [View_UP6_Xls_Extracts.Test_View]. (TSK-10037)

[I] 2013-03-09 09:00:24.439 Subtask process [subtask id=621] was dispatched to the Job Server [l223sr219:3510, PID=25588]. (TSK-10088)

[I] 2013-03-09 09:00:44.449 Profiling engine section. (TSK-10015)

[I] 2013-03-09 09:00:44.459 The Subtask process [subtask id=621] has finished with error: Data flow <DF_Rule_NP_18_1_CREATE> received a bad system message. Message text from the child process is <￯﾿ᄄ￯﾿トT￯ᄒロ:&#127;==========================================================

Collect the following and send to Customer Support:

1. Log files(error_*, monitor_*, trace_*) associated with this failed job.

2. Exported ATL file of this failed job.

3. DDL statements of tables referenced in this failed job.

4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when the job failed.

5. Core dump, if any, generated from this failed job.

==========================================================

>. The process executing data flow <DF_Rule_NP_18_1_CREATE> has died abnormally. For NT, check errorlog.txt. For HPUX, check stack_trace.txt. Also, notify Technical Support.. (TSK-10091)

[I] 2013-03-09 09:00:44.613 Processed [1] of [1] sub tasks. (TSK-10047)

[I] 2013-03-09 09:00:44.616 Summary of task [view_tas] with [1] subtask(s) executed. (TSK-10005)

[I] 2013-03-09 09:00:44.625 [1] Subtask(s) executed with errors. (TSK-10007)

[I] 2013-03-09 09:00:44.627 [0] Rules executed successfully. (TSK-10009)

[I] 2013-03-09 09:00:44.633 Subtask [run id=1] Table View_UP6_Xls_Extracts.Test_View: Data flow <DF_Rule_NP_18_1_CREATE> received a bad system message. Message text from the child process is <￯﾿ᄄ￯﾿トT￯ᄒロ:&#127;==========================================================

Collect the following and send to Customer Support:

1. Log files(error_*, monitor_*, trace_*) associated with this failed job.

2. Exported ATL file of this failed job.

3. DDL statements of tables referenced in this failed job.

4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when the job failed.

5. Core dump, if any, generated from this failed job.

==========================================================

>. The process executing data flow <DF_Rule_NP_18_1_CREATE> has died abnormally. For NT, check errorlog.txt. For HPUX, check stack_trace.txt. Also, notify Technical Support. (TSK-10008)

[I] 2013-03-09 09:00:44.731 Task process finished with errors. Status is set to failed. (TSK-10027)

[I] 2013-03-09 09:00:44.733 Utility processing ended.

[E] 2013-03-09 09:00:44.740 Utility failed with code 4. (COR-10020)

[I] 2013-03-09 09:00:44.741 Completed execution on 2013-03-09 09:00:44. (COR-10015)

[I] 2013-03-09 09:00:44.743 Elapsed time is 0:23.689 [min:sec.millisec]. (COR-10084)

[C] 2013-03-09 09:00:44.748 Information Steward repository connections are shutting down. (COR-10367)

 

 

Has anybody tried data profiling using File connection?

Any help or suggestions would be appreciated.

 

Regards,

Tej

Actions