Skip to Content
0
Former Member
Apr 27, 2014 at 09:58 AM

EmployeeDetailsBAPI, OrgUnitHierarchy2 tables are not get created and ActivePerson not loaded with data

37 Views


Dear Experts,

We are on Nakisa OrgAudit 4.0 SP1 with Build no 0910021800. Database MSSQL 2012

My main issue is Im not able to Save the audit which I ran. I can see only two buttons enabled Preview Audit and Discard. the Save Audit button is disabled to save the audit. Screen shot provided for reference.

Im trying to connect the standard version of OrgAudit build to client's data. I followed below steps.

1. Loaded the standard build OrgAudit_SqlServer and saved as 'znak_oa_sql_tst'.

2. Set up the data connections and checked SAP Connection and Data base destination connections. Both the test connections are successful.

3. Using the sap service user with the required authorizations to fetch the data from SAP. I checked few function modules like BAPI_EMPLOYEE_GETDATA and its able to fetch data properly.

4. Using MSSQL database user with the required authorizations like Read/Write/Alter/Drop

5. Set up the security settings in admin console

6. Set up the Confugire staging and extracted the data with Extract data from SAP and Execute Joins on extracted data.

7. Here I would expect the tables like OrgUnitHierarchy2, EmployeeDetailsBAPI, PositionHierarchy created on the database. But the tables are not getting created.

8. I recreated the database structure but no traces of the mentioned tables.

9. When I checked the log, the statements getting failed with the errors like '

BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT Pernr, ComnLongId AS PhoneNo1 into EmployeeDetailsBAPITemp1

FROM EmpCommn

WHERE (ComnType = '0020')]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'ComnType'.

Here the statement failing because the database table EmpCommn has COMNTYPE as the column so its not accepting the ComnType. Like this many statements getting failed.

10. I tried modifying the joinsconfiguration.xml to resolve the issues with the database statements. (I doubt should I change the join config for sake of keyword/table case sensitive issues. I believe the issue should be with database). After modifying the joinsconfig.xml, most of the errors got resolved and new tables got created. But many important tables doesnt have any data.I extracted the data many times but no success.

Im attaching the generated audit run and cds.log.

Please provide your valuable suggestions to overcome this issue.

Thanks and Regards,

Manohar