Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

42S02: [Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid object name 'dbo.sysextendedarticlesview

Posted By JPSinMN over 2 years ago

Sage Premium version 2020

Reinitialize Datafiles utility

I get the above message/problem when trying to reinitialize any AP or AR data files. I don't get the message when reinitializing IM, PO and SO files. So when this message pops up I have to select OK,and then it pops up for every file that I selected to reinitialize. Selecting OK Skips the file I selected, and results in none of my selected files getting reinitialized.

HELP!

0 JPSinMN over 2 years ago
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 FormerMember over 2 years ago

It looks like it's having a problem with a VIEW definition not a table.
Cancel
Vote Up -1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 2 years ago in reply to JPSinMN

Is MAS_User the database owner?

SQL Server Native Client 11 installed on the machine? (You should be able to verify that in the dialog to add a new 32-bit DSN).

Also, verify the SQL Collation for the server and database. Anything other than the exact correct value is really bad, and can cause all kinds of corruption.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

42S02: [Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid object name 'dbo.sysextendedarticlesview

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING