I am trying to warehouse data from Arev to MS sql by using OI. The Arev data is coming from a Ceridian Application. I was able to add the Arev table to OI, however, when I tried to create a popup or form based on the table I got the following error and was kicked into the debuger : "sys1000 error loading program 'auditlog.mfs'"

Is there any way around this so that i may utilize this Arev table in OI or should I contact Ceridian?

Thanks

Alan

The easiest way is to remove the MFS but that'd screw the AREV system so either copy $AUDITLOG.MFS from arev sysobj to oi SYSOBJ or create a new "blank" MFS in OI.

Andrew P McAuley

A Hotel Room In Holland Without His Normal Sig

A Howard,

I am trying to warehouse data from Arev to MS sql by using OI. The Arev data is coming from a Ceridian Application. I was able to add the Arev table to OI, however, when I tried to create a popup or form based on the table I got the following error and was kicked into the debuger : "sys1000 error loading program 'auditlog.mfs'"

First, make sure the Arev application is using Arev v3.1 or later or else OpenInsight may automatically change the dictionaries and indexes of the application, which would be bad. (If it is an earlier version, best bet is to Warehouse a copy of the database, not the main database itself.)

Second, the AUDITLOG.MFS is part of the Arev HR application. Assuming you are using a copy of the database, you can remove the MFS using Set_MFS (see help file). Otherwise you will need to create a synonym in the REVMEDIA table of that volume.

Third, there is a helpful doc called Data Warehousing: SQL Server Specifics in the OpenInsight Knowledge Base on warehousing to SQL Server.

Cameron Purdy

info@revelation.com

View this thread on the forum...