Hi All,
We are getting this error when trying to save a journal.
Error : "EPMHFM-7400: An error occurred in executing the previously prepared ODBC command"
This issue exists in one application(which is recently copied/cloned from production via DB link) in TEST environment. In rest of the applications there is no issue when saving a journal.
Below is the error message in the xfm.odl log.
[2017-08-21T04:25:15.535845-06:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CHsvDSSystemInfo.cpp] [Line: 6213] [userId: ] [appName: sample] [pid: 5580] [tid: 12988] [host: wephfmt1] [nwaddr: [fe80::80a4:7f4c:4a19:8ef2%13]:0;[fe80::94fb:f112:c171:ba6a%12]:0;130.30.4.63:0;10.32.19.208:0;10.32.49.179:0;10.32.33.154:0;[2002:821e:43f::821e:43f]:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.204.5264] [[SYSINFO:Application=sample; PID=5580; NumUsers=1; CPU(Cores)=32; NumTasks=1; NumErrors=5; PhysicalMem=68608245760; UsedPhysicalMem=18383577088; ProcUsedPhysicalMem=2916433920; VirtualMem=140737488224256; UsedVirtualMem=5567758336; ProcUsedVirtualMem=2993786880; UsedCPU=0.547058; ProcUsedCPU=3.53093; NumCubesInRAM=34; NumDataRecordsInRAM=569719; NumRecordsInLargestCube=105217]]
[2017-08-21T04:25:24.411017-06:00] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: 00ihTSi5wsMEsHwDwFy0SW0002fW00030A] [File: XfmODBC.cpp] [Line: 203] [userId: ] [appName: sample] [pid: 5580] [tid: 19380] [host: wephfmt1] [nwaddr: [fe80::80a4:7f4c:4a19:8ef2%13]:0;[fe80::94fb:f112:c171:ba6a%12]:0;130.30.4.63:0;10.32.19.208:0;10.32.49.179:0;10.32.33.154:0;[2002:821e:43f::821e:43f]:0;] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = HY000; NATIVE ERROR = 2289; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-02289: sequence does not exist]]
[2017-08-21T04:25:24.411017-06:00] [XFM] [ERROR:1] [EPMHFM-07400] [XFM] [ecid: 00ihTSi5wsMEsHwDwFy0SW0002fW00030A] [File: CHsvDSJournals.cpp] [Line: 4270] [userId: ] [appName: sample] [pid: 5580] [tid: 19380] [host: wephfmt1] [nwaddr: [fe80::80a4:7f4c:4a19:8ef2%13]:0;[fe80::94fb:f112:c171:ba6a%12]:0;130.30.4.63:0;10.32.19.208:0;10.32.49.179:0;10.32.33.154:0;[2002:821e:43f::821e:43f]:0;] [errorCode: 800402BD] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.204.5264] An error occurred in executing the previously prepared ODBC command. [[]]
Regards,
Maku