Delete the UQ or UR records from CSAPP, then Activate, the UNI database is created automatically.

Thanks Jay.....from System database?

No, company.

Company database

I only have UP and UT records in Sample company

Then just activate it.

Then it is not active.

I dont have any in Sample. So I check my customer database and I found those records. So I delete and I can open company without any issue and icons without any error....BUT once I activate Ops Inquiry there I get those problems.....image header desktop menus dissappear and can't run any icons....strange....I will reinstall Ops Inquiry to check if that helps......

Yes when activate now get the issue. I check SQL and database is created but Sage fails for some reason!!!

Something is wrong with your setup. What do you have in the SERVER field in Sage 300 database setup?
Why are you concerned with Ops Inquiry?

As always....in this case MY-PC\MSSQLSAGE.....as this customer send me DBdump with Ops Inquiry Activated once I tried to open first time I get errors related with Ops Inquiry so I tried wth Sample company....and also get those errors just when actívate !!!

Ignore the errors. You don't need Ops inquiry.

1. Ops Inquiry is a pig, I suspect it does not like the SQL instance name. Try creating an ODBC DSN
2. Dump does not include Ops Inquiry data (there is no data anyway), so why worry about it?

I cant ignore. Once I actívate, I cant run any sage icon (GL, AR, AP, OE, PO, IC)....so I just DBLoad again, delete records you ask me in CSAPP and can work again.....if activate Sage doesnt work !!! Why? Not sure.....thank you very much

I've never had that problem before, I just ignore the "cannot find xxxx_UNI" database error. Therefore Ops inquiry is not your problem, you have another one.

I've never had that problem before, I just ignore the "cannot find xxxx_UNI" database error. Therefore Ops inquiry is not your problem, you have another one.

Just FYI, we found similar errors in Sage 300 2017 (PU2), and found a solution:

On activating OpsInquiry, we got the same errors: "header desktop images disappear from UI and if I tried to run any Icon I get Cannot run UI" plus module names disappeared from System Information. (Before activating OpsInquiry, UNI database did not exist, UQ entry did not exist in CSAPP, and there were no errors). Other company databases without OpsInquiry had no problems.

Exited Sage300 then opened it. Immediately got “Desktop has stopped working”. After lots of experimenting and  testing we realised we had been running Sage300 by running accpac.exe directly from the local programs folder, or from a desktop shortcut we made from it, but we had originally installed via a UNC address, so the Shared Programs, Shared Data and PATH pointed to the UNC address, not to the local drive. We then ran Sage300 from the Windows Start entry that was created by the installation, (and therefore pointed to the UNC address) and the problems went away.

The problems did not occur for databases that did not have OpsInquiry activated, and we could turn the problem off by reloading the non OpsInquiry data, and turn it back on by activating OpsInquiry.

Back to Basics

Steve