EMM: Running Search Index on EP_WM_WO_RESOURCES_KIB, Abends with SQL Error "Conversion failed when converting the varchar value '0000000001-' to data type int." in SQL Server Only.
(Doc ID 3005684.1)
Last updated on MARCH 08, 2024
Applies to:
PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Running search index build on EP_WM_WO_RESOURCES_KIB and the job fails with the following SQL error:
Conversion failed when converting the varchar value '0000000001-' to data type int.
Replication Steps:
1) Navigate to PeopleTools -> Search Framework -> Search Admin Activity Guide -> Administration -> Deploy/Delete Object.
2) Select EP_WM_WO_RESOURCES_KI search index and click deploy button.
3) Build search index on the above one by navigating to PeopleTools -> Search Framework -> Search Admin Activity Guide -> Administration -> Schedule Search Index.
4) Click Run and process goes to success. But there is an error in the message log.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |