cancel
Showing results for 
Search instead for 
Did you mean: 

SYS-170101: System Exception

Former Member
0 Kudos

Hello,

A job failed with this error :

(12.2) 07-16-10 16:25:48 (E) (1081374:0001) SYS-170101: System Exception <Signal 9> occurred in the context <>

The version of ou DI is BODS 12.2, running on a AIX machine 5.3

The job read some Sybase IQ tables and updates a table still on Sybase IQ

The job starts the dataflow and then fail

(12.2) 07-16-10 16:08:06 (1146920:0001) DATAFLOW: Data flow <DF_xxx> using PAGEABLE Cache with <3578 MB> buffer pool.

(12.2) 07-16-10 16:25:48 (1081374:0001) WORKFLOW: Work flow <WF_xxx> is terminated due to an error <170101>.

(12.2) 07-16-10 16:25:48 (1081374:0001) JOB: Job <Job_xxx> is terminated due to error <170101>.

Thank you for your help

Accepted Solutions (0)

Answers (3)

Answers (3)

vnovozhilov
Employee
Employee
0 Kudos

Hello,

Acoording to KBA 1597307 - Job execution fails with SYS-170101 - System Exception <signal 9> error - Data Service... your source file may be saved with ANSI encoding. Open the source file in a text editor mode and re-save it with UTF-8 encoding.

Thank you,

Viacheslav.

Former Member
0 Kudos

hi,

any help on the below error log...,

44886608SYS-1701012/5/2014 10:56|Session TRANS_ARCHIVE102013|Work flow TrArchive 1-31_10_2013|Data flow TARCH_FLOW
44886608SYS-1701012/5/2014 10:56System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
44886608SYS-1701012/5/2014 10:56Call stack:
44886608SYS-1701012/5/2014 10:56(null)
44886608SYS-1701012/5/2014 10:56Registers:
44886608SYS-1701012/5/2014 10:56RAX=00000000752D1648 RBX=0000000000209AB8 RCX=0000000000209AB8 RDX=0000000000000160 RSI=00000000094D2D90
44886608SYS-1701012/5/2014 10:56RDI=0000000009406970 RBP=0000000000000000 RSP=00000000002099C0 RIP=000000007526730A FLG=0000000000010206
44886608SYS-1701012/5/2014 10:56R8=0000000000000000 R9=00000000FFFFFFFF R10=0000000000310039 R11=00000000093EA270 R12=0000000000372640
44886608SYS-1701012/5/2014 10:56R13=0000000081D6FEC0 R14=000000000020A008 R15=000000000020A030
44886608SYS-1701012/5/2014 10:56Exception code: C0000005 ACCESS_VIOLATION
44886608SYS-1701012/5/2014 10:56Fault address:  000000007526730A 01:000000000002630A
44886608SYS-1701012/5/2014 10:56C:\Windows\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_88df89932faf0bf6\MSVCP80.dll
44886608SYS-1701012/5/2014 10:56==========================================================
44886608SYS-1701012/5/2014 10:56Collect the following and send to Customer Support:
44886608SYS-1701012/5/2014 10:561. Log files(error_*, monitor_*, trace_*) associated with this failed job.
44886608SYS-1701012/5/2014 10:562. Exported ATL file of this failed job.
44886608SYS-1701012/5/2014 10:563. DDL statements of tables referenced in this failed job.
44886608SYS-1701012/5/2014 10:564. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
44886608SYS-1701012/5/2014 10:56the job failed.
44886608SYS-1701012/5/2014 10:565. Core dump, if any, generated from this failed job.
44886608SYS-1701012/5/2014 10:56==========================================================
44886608SYS-1701012/5/2014 10:56|Session TRANS_ARCHIVE102013|Work flow TrArchive 1-31_10_2013|Data flow TARCH_FLOW
44886608SYS-1701012/5/2014 10:56System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
44886608SYS-1701012/5/2014 10:56Call stack:
44886608SYS-1701012/5/2014 10:56(null)
44886608SYS-1701012/5/2014 10:56Registers:
44886608SYS-1701012/5/2014 10:56RAX=00000000752D1648 RBX=0000000000209AB8 RCX=0000000000209AB8 RDX=0000000000000160 RSI=00000000094D2D90
44886608SYS-1701012/5/2014 10:56RDI=0000000009406970 RBP=0000000000000000 RSP=00000000002099C0 RIP=000000007526730A FLG=0000000000010206
44886608SYS-1701012/5/2014 10:56R8=0000000000000000 R9=00000000FFFFFFFF R10=0000000000310039 R11=00000000093EA270 R12=0000000000372640
44886608SYS-1701012/5/2014 10:56R13=0000000081D6FEC0 R14=000000000020A008 R15=000000000020A030
44886608SYS-1701012/5/2014 10:56Exception code: C0000005 ACCESS_VIOLATION
44886608SYS-1701012/5/2014 10:56Fault address:  000000007526730A 01:000000000002630A
44886608SYS-1701012/5/2014 10:56C:\Windows\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_88df89932faf0bf6\MSVCP80.dll
44886608SYS-1701012/5/2014 10:56==========================================================
44886608SYS-1701012/5/2014 10:56Collect the following and send to Customer Support:
44886608SYS-1701012/5/2014 10:561. Log files(error_*, monitor_*, trace_*) associated with this failed job.
44886608SYS-1701012/5/2014 10:562. Exported ATL file of this failed job.
44886608SYS-1701012/5/2014 10:563. DDL statements of tables referenced in this failed job.
44886608SYS-1701012/5/2014 10:564. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
44886608SYS-1701012/5/2014 10:56the job failed.
44886608SYS-1701012/5/2014 10:565. Core dump, if any, generated from this failed job.
44886608SYS-1701012/5/2014 10:56==========================================================
Former Member
0 Kudos

Hi Nicolas,

Just guessing, but Signal 9 looks like it would be something to do with kill -9.

Could this be a memory issue?

- You are loading a table in the same database, are you pushing down the code?

(does the sql in View->optimized sql, when the job is selected - have an insert or command?)

- Does this happen when you are using small volumes of data?

- try a "top" to see DS's memory usage.

- Does it still happen when you raise your ulimit values for memory for the DS user?

Regards

Norbert

werner_daehn
Active Contributor
0 Kudos

The error log message would help in addition the the error code.

Bada
Discoverer
0 Kudos

Werner,

  I too get the same error. Here is detailed error log and monitor. What could be the reason to get the error? Thanks in advance.

Errorr log: ( contain only one line)

(E) (28967056:0001) SYS-170101: System Exception <Signal 9> occurred in the context <>

Monitor: (last few lines)

/Bill_to_create1/Query_1_2_2, PROCEED, 265000, 14.166, 68.718

/Bill_to_create1/Query_6_1-Join41: 1, PROCEED, 265000, 14.165, 68.719

/Bill_to_create1/Query_6_1, PROCEED, 0, 0.000, 68.743

/Bill_to_create1/Query_9_1-Mapping48, PROCEED, 0, 0.0000, 68.744

@SYS-170101, ERROR, 0, 0.000, 68.986, 0.000, 0, SYS-170101: System Exception <Signal 9> occurred in the context <>

Trace:  ( last 3 lines of trace)

(14.0) 11-20-12 15:39:46 (19726552:0001) DATAFLOW: Data flow <Bill_to_create1> using IN MEMORY Cache.

(14.0) 11-20-12 15:40:40 (28967056:0001) WORKFLOW: Work flow <WF_Accounts_create> is terminated due to an error <170101>.

(14.0) 11-20-12 15:40:40 (28967056:0001)      JOB: Job <IDD9903_Acc_Create_Billto> is terminated due to error <170101>.