Failed SQL stmt: TRUNCATE TABLE .PSAPMSGDOMSTAT
edited Apr 10, 2019 12:57PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 10 commentsAnswered ✓
Getting below errors while running truncate in purge scripts after full database refresh. Executing as sysadmin in data mover and truncates are only failing and updates/inserts are fine. For some reason it is expecting fully qualified schema name for truncate (<schema.tablename>). Is there any privilege/role/trigger we are missing to get this through without changing the scirpts?
File: Data MoverSQL error. Stmt #: 0 Error Position: 15 Return: 903 - ORA-00903: invalid table name
Failed SQL stmt: TRUNCATE TABLE .PSAPMSGDOMSTAT
Error: SQL execute error for %TruncateTable(PSAPMSGDOMSTAT)
Ended: Mon Apr 8 17:03:52 2019
Unsuccessful completion
2