12.2.5.1 engine bulk loader errors: ora-04043: object tempmdptable1 does not exist (Doc ID 2137875.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Customer has installed Demantra is 12.2.5.1. They have configured the engine
by creating a repository in the Oracle wallet as per Doc ID Demantra is
12.2.5.1

Customer has 64bit windows 2012 server
Oracle client is 32 bit 12.1.0.2.0
The db host is 17.0.5.110. The Engine is running on 17.0.5.111.

When they run the batch engine, they get the Warning message on bulk loader
However, they see the forecast in the worksheet
But when they run the simulation they see the same bulk loader issue but
forecast is always 0

The following checks/action have been done but issue persists

1.Checked that they can execute the sqlldr from the command line
2.The PATH Variables are correct
3.The engine has been registered too
4. Truncate ENGINE_CACHES table in the schema
5. Delete <Root>/please delete <Root>/Demand
Planner\AnalyticalEngine\bin\Caches directory
6. Made sure there is no outof sync data
UPDATE MDP_MATRIX
SET FROM_DATE = NULL,
UNTIL_DATE = NULL;
COMMIT;
EXEC UPDATE_MDP_MATRIX_DATES;
7. EngineStarter is up and running

8. There are nologs files only ctl files after sqlldr.exe call

9. Did the following

Go to Engine's 'bin' directory. Try to run SQLLDR.exe from there, using a
similar command line to:
C:\demantra12.2.5_QA\Demand Planner\Analytical Engines\bin>sqlldr.exe
dm_qa_1/dm
_qa_1@17.0.5.110:1521/DEMT control=TempMdpTable1_1_2.ctl
log=TempMdpTable1_1_2.l
og bad=TempMdpTable1_1_2.bad errors=0 data=MdpData_1_1_1.txt direct=TRUE
paralle
l=FALSE

SQL*Loader: Release 11.2.0.1.0 - Production on Tue Feb 9 01:40:11 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

SQL*Loader-941: Error during describe of table TEMPMDPTABLE1
ORA-04043: object TEMPMDPTABLE1 does not exist

10. Based on the above error customer tried to create table TEMPMDPTABLE1
manually and ran the command below. The data got obviously loaded. Data is in
the DB table.
C:\demantra12.2.5_QA\Demand Planner\Analytical Engines\bin>sqlldr.exe
dm_qa_1/dm
_qa_1@17.0.5.110:1521/DEMT control=TempMdpTable1_1_2.ctl
log=TempMdpTable1_1_2b.
log bad=TempMdpTable1_1_2.bad errors=0 data=MdpData_3_1_2.txt direct=TRUE
parall
el=FALSE

SQL*Loader: Release 11.2.0.1.0 - Production on Wed Feb 10 12:54:35 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Load completed - logical record count 75.

C:\demantra12.2.5_QA\Demand Planner\Analytical Engines\bin>

**************************************************

After that they tried to run the batch engine again but the batch Engine is
not finishing
They are still getting

06:28:34:957 ERROR The bulk insert procedure failed to execute successfully!
Error: 0x5 - Access is denied.
, Error: 5, Command: DM_QA_1/***@17.0.5.110:1521/DEMT
control=ENGINE_BRANCH_LIST_Man_1.ctl log=ENGINE_BRANCH_LIST_Man_1.log
bad=ENGINE_BRANCH_LIST_Man_1.bad errors=5 data=ManagerBranchList.txt
direct=TRUE parallel=TRUE, Retry: 19
06:28:35:066 ERROR Error executing the bulk loader!

11. Again they try to execute the EngineManager.exe (*/bin/EngineManager.exe
17.0.5.110:1521/DEMT dm_qa_1 dm_qa_1 1 1) from the older Demantra version
12.2.5 it executes fine. Therefore they would expect that the environment
variables are correctly setup. The same command is giving them the SQLLDR
error on Demantra version 12.2.5.1.

12.They started the console from the normal user as well as the
administrator. The results are the same.

13. They tried without the wallet setting but still the engine does not work
there too.

14. They did also additional tests by installing Demantra locally on their
laptops (Windows 10) and running the engine from there
a) by connecting to the remote DB server
b) copying the schema to the local DB
In both cases the results are the same. The SQLLDR isn't able to write the
results back.

15. They tried both 32 bit and 64 bit



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms