Remove 'CID' from Adobe Import

goosetuv / Snow-Platform-Monitor

Windows Tool for doing platform checks on Snow Software platforms (Morning Checks)

MIT License

0 stars 0 forks source link

Remove 'CID' from Adobe Import #13

Closed Laim closed 3 years ago

Laim commented 3 years ago

2021-03-01 12:50:12,881 [1] FATAL SnowPlatformMonitor.Service.SnowPlatformMonitor [ServiceExporter] - System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CID'.

Adobe Import table has been updated in SLM to remove the 'CID' column, this causes a FATAL error during export

Laim commented 3 years ago

Work Around (pre v1.3)

Disable the Adobe Export in the SPM Configuration GUI

Work Around (v1.3)

Go to C:\Program Files\Laim McKenzie\Snow Platform Monitor\Resources\
Open sql.resource
Update the AdobeImport at the top and remove 'CID'
Or replace it with : SELECT ImportID, AddedDate FROM SnowLicenseManager.adobecc.Import