Duplicate Asset ID and Suffix Error When Adding a New Asset

Filed in Uncategorized Comments Off

Problem: Duplicate Asset ID and Suffix Error When Adding a New Asset. This problem is related to Microsoft Great Plain FA module. I found this error in GP 7.5 and 9.0

Solution: Take backup of your database depending on your condition.  Run a delete statement on the FAINDEX in your Company database. “Delete FROM FAINDEX”

,

The partner transaction manager has disabled its support for remote/network transactions

Filed in Uncategorized Comments Off

Problem:The partner transaction manager has disabled its support for remote/network transactions. An error occurred while enlisting in a distributed transaction.

Solution: This error comes up when you are doing inter sever transactions via Distributed Transaction Cordinator MSDTC. You need to set some setting on your machine.

In Control Panel > Adminstrative Tools > Component Services > Expand Component Service > Right Click My Computers > Properties > MSTDC Tab > Click on Security Configuration button > Check Network DTC if not checked and Check Allow Inbound, Allow Outbound and select NO AUTHENTICATION REQUIRED.

, ,

Specified owner name 'dbo' either does not exist or you do not have permission to use it

Filed in Uncategorized Comments Off

I found this error when I try to get or insert into Microsoft Dynamics Great Plains through eConnect.

Problem: {System.Data.SqlClient.SqlError: Specified owner name ‘dbo’ either does not exist or you do not have permission to use it.} object {System.Data.SqlClient.SqlError}

Solution: First of all domain user should be added in your SQL Server Logins. Give db_owner Role to that domian user in SQL Server through which you give call to SQL Server via eConnect, this is the same user through which you install eConnect service when installing eConnect. I found it as a one time problem you can revert it after the sucessful calls of all entities, probebly first time it is create some db object for which it requires some extra previllages, this is the same user with which you install eConnect service and your GP transaction are done by this user.

, ,

TOP