BODS crashes during import

dataservices administration
1

Hi,

I am getting the following errors in error log during import of one job to BODS 3.2.

Kindly advise.

FIRST following errors:-
(12.2) 10-20-11 09:35:44 (E) (4440:5252) CON-120402: Cannot find NT Oracle Server DLL <OCI.DLL>. Please make sure that Oracle has been installed and the PATH variable points to the
correct lib directories.
(12.2) 02-01-12 18:40:32 (E) (1728:3456) RES-020107: Referencing undeclared variable <$G_SYSDATE>. Please declare the variable in the context it is being used in.
(12.2) 02-01-12 18:41:35 (E) (1728:3456) RES-020107: Referencing undeclared variable <$G_DUMMY>. Please declare the variable in the context it is being used in.
(12.2) 02-01-12 18:41:35 (E) (1728:3456) RES-020107: Referencing undeclared variable <$G_ERR_KBN>. Please declare the variable in the context it is being used in.
(12.2) 02-03-12 10:40:32 (E) (3856:2964) CON-120404: OCI call for connection failed: <ORA-01017:

THEN:-

Error calculating column mappings for data flow <DM_PRTLOGTK_N200_03_01_DF>. Please validate the data flow, fix any errors, and
retry the column mapping. If the problem persists, please notify Customer Support.
(12.2) 03-25-13 20:16:15 (W) (7752:2068) VAL-030359: |DATAFLOW DM_OLD_USER_N200_DF|STATEMENT <GUID::‘87701f27-690a-4382-986c-1d640d22a7e3’ LOAD TABLE ORN20XSD.ORN20XSD.DTN201_KJNPRTLOG INPUT(DM_OLD_USER_N200_Query)>
Error calculating column mappings for data flow <DM_OLD_USER_N200_DF>. Please validate the data flow, fix any errors, and retry
the column mapping. If the problem persists, please notify Customer Support.
(12.2) 03-27-13 17:12:03 (E) (11048:9128) SYS-170101: System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\Program Files (x86)\Business
Objects\BusinessObjects Data Services\log\BODI_MINI20130327171131_11048.DMP> and <C:\Program Files (x86)\Business
Objects\BusinessObjects Data Services\log\BODI_FULL20130327171131_11048.DMP>
Process dump is written to <C:\Program Files (x86)\Business Objects\BusinessObjects Data
Services\log\BODI_MINI20130327171131_11048.DMP> and <C:\Program Files (x86)\Business Objects\BusinessObjects Data
Services\log\BODI_FULL20130327171131_11048.DMP>
Call stack:
(null)
0023:018F84C6, CUIStackTrace::~CUIStackTrace()+7376470 byte(s)
0023:018D9A21, CUIStackTrace::~CUIStackTrace()+7250865 byte(s)
0023:018FC658, CUIStackTrace::~CUIStackTrace()+7393256 byte(s)
0023:018FE9AA, CUIStackTrace::~CUIStackTrace()+7402298 byte(s)
Registers:
EAX=2DF0CEC0 EBX=00000000 ECX=2EEDCEC0 EDX=00000AA2 ESI=0E36BA40
EDI=00000000 EBP=0017EF90 ESP=0017EE1C EIP=2CF3CEC0 FLG=00010246
CS=0023 DS=002B SS=002B ES=002B FS=0053 GS=002B
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 2CF3CEC0 00:00000010
(12.2) 03-27-13 18:04:52 (E) (3292:10928) SYS-170101: System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\Program Files (x86)\Business
Objects\BusinessObjects Data Services\log\BODI_MINI20130327180443_3292.DMP> and <C:\Program Files (x86)\Business
Objects\BusinessObjects Data Services\log\BODI_FULL20130327180443_3292.DMP>
Process dump is written to <C:\Program Files (x86)\Business Objects\BusinessObjects Data
Services\log\BODI_MINI20130327180443_3292.DMP> and <C:\Program Files (x86)\Business Objects\BusinessObjects Data
Services\log\BODI_FULL20130327180443_3292.DMP>
Call stack:
(null)
0023:018F84C6, CUIStackTrace::~CUIStackTrace()+7376470 byte(s)
0023:018D9A21, CUIStackTrace::~CUIStackTrace()+7250865 byte(s)
0023:018FC658, CUIStackTrace::~CUIStackTrace()+7393256 byte(s)
0023:018FE9AA, CUIStackTrace::~CUIStackTrace()+7402298 byte(s)
Registers:
EAX=2CF3CEC0 EBX=00000000 ECX=2BF6CEC0 EDX=020FF630 ESI=0E3ABC70
EDI=00000000 EBP=0017EF90 ESP=0017EE18 EIP=2DF0CEC0 FLG=00210246
CS=0023 DS=002B SS=002B ES=002B FS=0053 GS=002B
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 2DF0CEC0 00:00000010
(12.2) 03-27-13 18:18:04 (E) (11752:10836) SYS-170101: System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\Program Files (x86)\Business
Objects\BusinessObjects Data Services\log\BODI_MINI20130327181749_11752.DMP> and <C:\Program Files (x86)\Business
Objects\BusinessObjects Data Services\log

its_ranjan (BOB member since 2011-02-16)

2

Error occurs when reconciling repository stage during the last part of import. Any hint?

its_ranjan (BOB member since 2011-02-16)

3

For the first error try locating the OCI.DLL file in the Oracle install directory and copying it into the BIN directory for Data Services. I think I’ve had to do that a couple of times. Then again, make sure that the Oracle client has been properly installed.

If you get errors that a variable isn’t available and you’re importing the job that has the variable declared then you have a bigger problem than just importing.

I’m not sure about the crash. Are the export and import environments the same version? Are you using XML or ATL export? I stick with ATL exports 100% of the time. Too many problems with XML.

eganjp :us: (BOB member since 2007-09-12)

4

Hi Jim,

Other ATL file gets imported well successfully into this repository.
This ATL gets imported successfully into other repository.
This ATL when imported into this repository causes designer to crash.

its_ranjan (BOB member since 2011-02-16)

5

It sounds like a problem with that specific repository then. I’ve encountered repositories that are just plain corrupted. It has happened only twice in the past 10 years.

eganjp :us: (BOB member since 2007-09-12)