We have our SAP system (ECC 6.0) on UNIX (OS is AIX 6.1).
I have installed DS 3.2 on a Windows Server 2008 R2 for the SAP GL Rapid Mart (Single Box Installation). Our Target DWH is on Oracle 10g.
We are providing the following values for Source Data Store Configuration:
Data Transfer Method : Shared Directory
Working Directory on SAP server : /dstest (since its UNIX)
Application Path to Shared Directory : /dstest
Now, when I run the first job i.e. “Metadata_Load_SAP” I get the following error
“Cannot open file </dstest/SAPVersion.dat>. Please check its path and permissions.”
DS is running under a Domain Account with Admin rights on the same machine.
Our UNIX server (SAP server) is on the same Network but is NOT on Domain.
We enable the “samba” service on our UNIX machine so the the folder “dstest” can be access by our ETL server (Windows Environmnet). Now we can access this share directory at UNIX (dstest) with \ip\dstest. It is working fine now. The Metadata_Load for SAPGL_RM(3.2) run successfully.
Now during the GL_New_Load_SAP we faced an error saying “ORA-14400: inserted partition key does not map to any partition”
for table ‘LEDGER_SUMMARY_FACT_HZ’
I haven’t used the RapidMart for a while. The error message says that your table is partitioned by one thing, but a different element is inserted.
Example: I have a table with two partitions, one is for ACTUAL_PLAN=‘A’, the other partition is for ACTUAL_PLAN=‘P’. Now I execute an insert with the column ACTUAL_PLAN=‘X’ - it will fail with your error message.
(BOB member since 2004-12-17)