You’re offline. This is a read only version of the page.
1,599
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
*This post is locked for comments
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
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.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (