Archived discussions are read-only. Learn more about SAP Q&A

OrgChart 3.0 SP3 issue (Log)

Hi experts,

Could you please help me analysing the log below? I am unable to connect with SQL database for OrgChart (staged) and generate analytics step.

Thanks!!

1. 17 Jan 2013 08:19:51 INFO  com.nakisa.Logger  - [Admin console] admin user 'admin' successfully logged in
2. 17 Jan 2013 08:20:13 INFO  com.nakisa.Logger  - ManagerInit: Time took to setup Build: 4405 ms
3. 17 Jan 2013 08:20:16 INFO  com.nakisa.Logger  - ManagerInit: Time took to load settingsResources: 313 ms
4. 17 Jan 2013 08:20:20 INFO  com.nakisa.Logger  - ManagerInit: Time took to load appResources: 1615 ms
5. 17 Jan 2013 08:20:21 INFO  com.nakisa.Logger  - ManagerInit: Time took to load extractorSchema: 182 ms
6. 17 Jan 2013 08:20:22 INFO  com.nakisa.Logger  - ManagerInit: Time took to load OTFSchema: 767 ms
7. 17 Jan 2013 08:20:22 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Role Mapping: 8 ms
8. 17 Jan 2013 08:20:22 INFO  com.nakisa.Logger  - ManagerInit: Time took to load Roles: 5 ms
9. 17 Jan 2013 08:23:55 INFO  org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
10. 17 Jan 2013 08:23:55 INFO  org.springframework.jdbc.support.SQLErrorCodesFactory  - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
11. 17 Jan 2013 08:23:55 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE COUNTSTABLE]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'COUNTSTABLE', because it does not exist or you do not have permission.
12. 17 Jan 2013 08:24:13 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(Read Table Function/BAPI).Downloading Tables Objid, Stabs
13. 17 Jan 2013 08:24:13 ERROR com.nakisa.Logger  - com.nakisa.framework.utility.Basics : SAP Language Key not found. Current Language = Portuguese
14. 17 Jan 2013 08:24:13 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: RFC_READ_TABLE took: 20ms
15. 17 Jan 2013 08:24:13 INFO  com.nakisa.Logger  - RfcReadTable.retrieveData: Transfer for 'HRP1003' from com.sap.mw.jco.JCO.Table to com.nakisa.framework.data.DataTable took 0 milliseconds.
16. 17 Jan 2013 08:24:13 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(Read Table Function/BAPI).  Completed
17. 17 Jan 2013 08:24:13 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE ASSISTANTSTATUS]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'ASSISTANTSTATUS', because it does not exist or you do not have permission.
18. 17 Jan 2013 08:24:13 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  ASSISTANTSTATUS Completed  | {Rows Affected: 0}
19. 17 Jan 2013 08:24:13 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(PositionFTE).Downloading Tables PositionFTE
20. 17 Jan 2013 08:24:14 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_REPORT took: 67ms
21. 17 Jan 2013 08:24:14 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(PositionFTE).  Completed
22. 17 Jan 2013 08:24:14 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE POSITIONFTE]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'POSITIONFTE', because it does not exist or you do not have permission.
23. 17 Jan 2013 08:24:15 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  POSITIONFTE Completed  | {Rows Affected: 10}
24. 17 Jan 2013 08:24:15 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(Active Employee).Downloading Tables Active Person
25. 17 Jan 2013 08:24:15 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: RFC_READ_TABLE took: 388ms
26. 17 Jan 2013 08:24:15 INFO  com.nakisa.Logger  - RfcReadTable.retrieveData: Transfer for 'PA0000' from com.sap.mw.jco.JCO.Table to com.nakisa.framework.data.DataTable took 81 milliseconds.
27. 17 Jan 2013 08:24:15 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(Active Employee).  Completed
28. 17 Jan 2013 08:24:15 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE ACTIVEPERSON]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'ACTIVEPERSON', because it does not exist or you do not have permission.
29. 17 Jan 2013 08:24:21 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  ACTIVEPERSON Completed  | {Rows Affected: 4763}
30. 17 Jan 2013 08:24:21 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(SAP Country Info).Downloading Tables Country Info
31. 17 Jan 2013 08:24:21 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_REPORT took: 156ms
32. 17 Jan 2013 08:24:21 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(SAP Country Info).  Completed
33. 17 Jan 2013 08:24:21 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE COUNTRYINFOT005T]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'COUNTRYINFOT005T', because it does not exist or you do not have permission.
34. 17 Jan 2013 08:24:22 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  COUNTRYINFOT005T Completed  | {Rows Affected: 644}
35. 17 Jan 2013 08:24:22 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(SAP Country Call Info).Downloading Tables Country Call Info
36. 17 Jan 2013 08:24:22 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_REPORT took: 118ms
37. 17 Jan 2013 08:24:22 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(SAP Country Call Info).  Completed
38. 17 Jan 2013 08:24:22 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE COUNTRYCALLINFOT005K]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'COUNTRYCALLINFOT005K', because it does not exist or you do not have permission.
39. 17 Jan 2013 08:24:23 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  COUNTRYCALLINFOT005K Completed  | {Rows Affected: 219}
40. 17 Jan 2013 08:24:23 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(PersonFTE).Downloading Tables PersonFTE
41. 17 Jan 2013 08:24:24 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_REPORT took: 914ms
42. 17 Jan 2013 08:24:24 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(PersonFTE).  Completed
43. 17 Jan 2013 08:24:24 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE PERSONFTE]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'PERSONFTE', because it does not exist or you do not have permission.
44. 17 Jan 2013 08:24:27 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  PERSONFTE Completed  | {Rows Affected: 3027}
45. 17 Jan 2013 08:24:27 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(Employee Extended).Downloading Tables Employee Extended
46. 17 Jan 2013 08:24:28 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_REPORT took: 169ms
47. 17 Jan 2013 08:24:28 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(Employee Extended).  Completed
48. 17 Jan 2013 08:24:28 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE EMPEXTENDED]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'EMPEXTENDED', because it does not exist or you do not have permission.
49. 17 Jan 2013 08:24:33 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  EMPEXTENDED Completed  | {Rows Affected: 4049}
50. 17 Jan 2013 08:24:33 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function RfcReadTable(Read Table Function/BAPI - OrgUnit Ids).Downloading Tables OrgUnit Ids
51. 17 Jan 2013 08:24:33 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_REPORT took: 154ms
52. 17 Jan 2013 08:24:33 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  RfcReadTable(Read Table Function/BAPI - OrgUnit Ids).  Completed
53. 17 Jan 2013 08:24:33 WARN  com.nakisa.Logger  -  : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [DROP TABLE ORGUNITIDS]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the table 'ORGUNITIDS', because it does not exist or you do not have permission.
54. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - SAP Extractor : Saving Table  ORGUNITIDS Completed  | {Rows Affected: 1214}
55. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - SAP Extractor : Processing Function  BAPI_SAP_OTFProcessor_Inheritance_Staged(Get Cost Center Info). Downloading Tables Cost Center Inheritance Data
56. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 163ms
57. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 42ms
58. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 52ms
59. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 42ms
60. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 44ms
61. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 42ms
62. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 42ms
63. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 63ms
64. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 55ms
65. 17 Jan 2013 08:24:35 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 86ms
66. 17 Jan 2013 08:24:36 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 74ms
67. 17 Jan 2013 08:24:36 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 66ms
68. 17 Jan 2013 08:24:36 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 64ms
69. 17 Jan 2013 08:24:36 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 47ms
70. 17 Jan 2013 08:24:36 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 55ms
71. 17 Jan 2013 08:24:36 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 42ms
72. 17 Jan 2013 08:24:36 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 43ms
73. 17 Jan 2013 08:24:37 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 704ms
74. 17 Jan 2013 08:24:37 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 59ms
75. 17 Jan 2013 08:24:37 INFO  com.nakisa.Logger  - FunctionRunner.executeFunctionDirect: /NAKISA/RFC_INHERITANCE took: 83ms

271768. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - Utility : getData : Index: 0, Size: 0
271769. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.nakisa.framework.data.commandProcessor.impl.SqlServerCommandProcessor : Problem executing query:<SELECT * FROM ORGUNITHIERARCHYNOTEXT> Data Element Name:  : Source {null}: Message {Invalid object name 'ORGUNITHIERARCHYNOTEXT'.}
271770. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ORGUNITHIERARCHYNOTEXT'.
271703. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - Utility : getData : Index: 0, Size: 0
271704. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.nakisa.framework.data.commandProcessor.impl.SqlServerCommandProcessor : Problem executing query:<SELECT * FROM ORGUNITHIERARCHYNOTEXT> Data Element Name:  : Source {null}: Message {Invalid object name 'ORGUNITHIERARCHYNOTEXT'.}
271705. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ORGUNITHIERARCHYNOTEXT'.
271638. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - Utility : getData : Index: 0, Size: 0
271639. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.nakisa.framework.data.commandProcessor.impl.SqlServerCommandProcessor : Problem executing query:<SELECT * FROM ORGUNITHIERARCHYNOTEXT> Data Element Name:  : Source {null}: Message {Invalid object name 'ORGUNITHIERARCHYNOTEXT'.}
271640. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ORGUNITHIERARCHYNOTEXT'.
271571. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - Utility : getData : Index: 0, Size: 0
271572. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - Analytics.DataUtility : deleteCounts : StatementCallback; bad SQL grammar [DELETE FROM CountsTable WHERE (HierarchyName='OrgUnitHierarchyNoText') and (CountName='TotalPersonFTE')]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'CountsTable'.
271573. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.nakisa.framework.data.commandProcessor.impl.SqlServerCommandProcessor : Problem executing query:<SELECT * FROM POSITIONHIERARCHYNOTEXT> Data Element Name:  : Source {null}: Message {Invalid object name 'POSITIONHIERARCHYNOTEXT'.}
271574. 17 Jan 2013 08:54:40 ERROR com.nakisa.Logger  - com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'POSITIONHIERARCHYNOTEXT'.

Tags:
  • SAP Moderator
replied

Marcelo.

  1. Are you sure the database account you're using from the Nakisa application has the proper permissions to access all the database tables?
  2. Do the referenced table in the SQL statements deinitely exist in the database and do they have any data in them?
  3. What happens if you try and run one of the failing SQL statements (e.g. one of the selects) in a SQL client using the same credentials as from the Nakisa application?  Do you get a more detailed error message?

Regards,

Stephen.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question