[BulkInsert] Timer failed with Invalid object name 'OSSYS_CYCLIC_JOB_SHARED
bulkinsert
Service icon
Forge component by Galter
Application Type
Service

We ran the timer which is for migrating the data (bulk insert)  from one module to another with different database catalogue for SQL Server , but the job failed with , Invalid object name 'OSSYS_CYCLIC_JOB_SHARED . All the logics were executed successfully and the timer failed internally .

This is happening across all environments.

We got support from official OutSystems and they pointed that , this is the issue with the plugin.

"The error observed, Invalid object name 'OSSYS_CYCLIC_JOB_SHARED, occurred because the extension 'BulkInsert' does not go back to the main catalog after the insert is executed in the different catalog. This means that the platform is not able to return to the 'main' catalog and tries to access a system table in the other catalog, where the table doesn't exist.
To surpass this issue, you need to ensure that the extension contains code to change back to the 'main' catalog once it finishes executing the database operations in the other catalog ".

Please look at this issue.

I know it doesn't address the full issue but you could try calling the bulk insert plugin again pointing to the main catalog and inserting some dummy data somewhere. That hopefully will reset your catalog. Messy but might help until the plugin is looked at.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.