SBX - Search With Button

SBX - Forum Post Title

SL2011 - Create additional empty application database

Microsoft Dynamics SL Forum

LongTimeGPandSL asked a question on 16 Apr 2019 9:58 PM
My Badges

Question Status

Suggested Answer

I've inherited a new SL Client that is still on version 2011.  They would like to create a new company, however I am running into a number of errors when attempting to create an "Additional Application Database".  The process runs with errors and the DBBuild.Log is referenced at the end of this post.  Upon completion, the database displays on the Database Maintenance Screen and the corresponding company can be added on under company maintenance.  Yet when I try to log into the new company, I receive the following message:

In troubleshooting, we also tried rebuilding procs and indexes, doing the security update, and resetting windows authentication for the logon method.  Neither seemed to have an affect and the logon error remained.

I am not finding references to the message on line.  Any thoughts as to what may be causing the DB Creation process to fail?  Please advise..

Here is the contents of the DBBuild.log file:

 

Start Time: 9:32:40 PM

Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\Budget_Dist_Type.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'Budget_Dist_Type'
Statement: Budget_Dist_Type, Budget_Dist_Type.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\EntryTyp.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EntryTyp'
Statement: EntryTyp, EntryTyp.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\FlexDef.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'FlexDef'
Statement: FlexDef, FlexDef.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PJCode.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJCode'
Statement: PJCode, PJCode.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PJContrl.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJContrl'
Statement: PJContrl, PJContrl.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PJDocnum.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJDocnum'
Statement: PJDocnum, PJDocnum.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PCSetup.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PCSetup'
Statement: PCSetup, PCSetup.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\Country.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'Country'
Statement: Country, Country.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDCommQual.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDCommQual'
Statement: EDCommQual, EDCommQual.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDConvMeth.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDConvMeth'
Statement: EDConvMeth, EDConvMeth.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDDataElement.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDDataElement'
Statement: EDDataElement, EDDataElement.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDRelease.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDRelease'
Statement: EDRelease, EDRelease.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDTransaction.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDTransaction'
Statement: EDTransaction, EDTransaction.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDVersion.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDVersion'
Statement: EDVersion, EDVersion.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\smProServSetup.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'smProServSetup'
Statement: smProServSetup, smProServSetup.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\smSVCCalendar.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'smSVCCalendar'
Statement: smSVCCalendar, smSVCCalendar.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\State.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'State'
Statement: State, State.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\TypeTransl.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'TypeTransl'
Statement: TypeTransl, TypeTransl.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\PJPFTSYS.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJPFTSYS'
Statement: PJPFTSYS, PJPFTSYS.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\SLIndex.csv: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'SLIndex'
Statement: SLIndex, SLIndex.csv


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\SLIndexCol.csv: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'SLIndexCol'
Statement: SLIndexCol, SLIndexCol.csv


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantRolePermissions'.
Statement: GrantRolePermissions 'U', 'MSDSL'
GO

 

Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Invalid object name 'glsetup'.
Statement: Database Maintenance


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantViewPermissions'.
Statement: GrantViewPermissions


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantTrustedWebService'.
Statement: MYCOMPANY: GrantTrustedWebService


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantReportUserPermissions'.
Statement: Add User E8F575915A2E4897A517779C0DD7CE

End Time: 9:45:05 PM

 

Please advise.  Look forward to a reply,

 

JG

Reply
StuartN responded on 17 Apr 2019 7:07 AM
My Badges
Suggested Answer

JG,

Looking at the errors, my guess would be that either the bcp files are missing from the ..\db\empty\app folder or they are restricted by rights. The rights issue (in my mind) is probably more relevant as the "Grant ..." procedures also are throwing errors. Make sure you have proper admin rights to the server.

Stuart Nottingham

Reply
LongTimeGPandSL responded on 17 Apr 2019 8:42 PM
My Badges

Hello Stuart,

Appreciate the input.  The BCP files are there.  Moreover supposedly I am logged in as a system administrator.  

That said, I may have stumbled upon something.   It seems the server in question is also a domain controller.  Given the DC configuration I am unable to view local group membership to verify if the logon is also a local admin.  Could there be potential issues with the machine being configured as a domain controller?

JG

Reply
StuartN responded on 17 Apr 2019 8:54 PM
My Badges

JG, I know that, in the past, having the DC and SQL on the same box was frowned upon. My recollection is that it was because both want to consume resources. Don't believe that's what is causing your problem though. Still feels like a rights issue to me.

Reply
Carolyn Froton responded on 22 Apr 2019 4:22 PM
My Badges

Hello JG,

Are you using a port? 1433 is the default for sql server , it should be open for incoming/outgoing traffic.

If you used a different port (some people do...) then perhaps that port is not open. And if you are using a different port, you need to include it on the login screen for db maintenance

Jana MacDonald

Microsoft Dynamics SL support

Reply
StuartN responded on 17 Apr 2019 7:07 AM
My Badges
Suggested Answer

JG,

Looking at the errors, my guess would be that either the bcp files are missing from the ..\db\empty\app folder or they are restricted by rights. The rights issue (in my mind) is probably more relevant as the "Grant ..." procedures also are throwing errors. Make sure you have proper admin rights to the server.

Stuart Nottingham

Reply

SBX - Two Col Forum

SBX - Migrated JS