Dynamics GP 2010 Web Services Installation – The Security ID structure is invalid. (Exception from HRESULT:0x80070539)
I been trying to install the web services for one of my clients, they are running a complicated environment, clustered SQL Server environment over three servers and clustered Hyper-V server to manage virtualized web applications like Workflow and Business Portal. We have installed the SharePoint Server Farm and configured the Load Balancer to manage the load balancing between servers and created web applications for both Workflow and Business Portal and then moved to the web services installation which was already installed on the production environment, unfortunately the installation never succeeded with the above error message.
Have you ever been in a situation where you wanted to change the SQL Collation to match SQL Database Collation?? Last year I have posted a script that resolves this for SQL Server 2005, but the same syntax is not applicable for SQL 2008 R2, while investigating this I found the correct syntax that need to be used as below: ” E:SQLsetup.exe ” /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME= MSSQLSERVER /SAPWD= P@ssW0rd /SQLCOLLATION= Arabic_CI_AI /SQLSYSADMINACCOUNTS=” DAOUD-PCDAOUD ” E:SQLsetup.exe will need to be replaced with the locations of the SQL Server 2008 R2 setup.exe path. MSSQLSERVER represents the default instance, if you have a named instance this must be changed to hold the instance name
one of my clients is a constructions firm whose not interested to activate the project accounting and wanted to distribute their project management over analytical accounting dimensions. Therefore we have implemented Dynamics GP and created dimension for projects to distribute all expenses accounts of analytical accounting codes. One of their requirements been to have a vendor statement per project which is reasonable for such a line of business, therefore I have created the below view that extracts the information including from AP, GL and AA and wanted to share the idea to avoid reinventing the weel for people who works with the same situation, below is the script I used: DECLARE @FROMDATE DATETIME DECLARE @TODATE DATETIME DECLARE @FROMVENDOR VARCHAR ( MAX ) DECLARE @TOVENDOR VARCHAR ( MAX ) SET @FROMDATE = ‘1900-01-01′ SET @TODATE = ‘2017-04-17′ SET @FROMVENDOR = ‘ACETRAVE0001′ SET @TOVENDOR = ‘BLOOMING0001′ SELECT ‘Beginning Balance’ AS TRXSOURCE , @FROMDATE AS DOCDATE , ‘Beginning Balance’ AS DOCNUMBER , VENDORID , SUM ( CREDIT ) AS CREDIT , SUM ( DEBIT ) AS DEBIT , VENDNAME , ‘Beginning Balance’ AS VCHRNMBR , ‘Beginning Balance’ AS TRXDESC , 0 AS JRNENTRY , 0 AS aaGLHdrID , aaTrxDimCode , aaTrxDimCodeDescr , ” AS LOCNCODE FROM ( SELECT DISTINCT VENDORTRANSACTION .
One of my clients requested to reconcile their GL Account Summary to GL Account Details periodically using SQL which is not currently available in Dynamics GP, I suggested to schedule a macro run but they wanted this to be done at the SQL level, therefore I have written the SQL command below to empty GL10110 table and repopulate the records to the tables using figures in GL20000. Find the script below or download it from this location .
Few weeks back I have posted about this error which was repeated again yesterday with one of my customers: Microsoft SQL Native Client SQL Server Cannot insert the value NULL into column ‘SEQNUMBR’, table dbo.IV10400, column does not allow nulls. UPDATE fails.
Guys, I am travelling to Jeddah after a couple of hours for long 5 days, if you would like to meet and exchange business cards, I will be normally in Break-time Café most of the time and my phone number below will be available all the time. Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 email@example.com www.mohdaoud.com