Issue in Connecting Postgres DB through PgAdmin (External)

Issue in connecting postgres DB externally through PgAdmin. Follow the below steps.

* Stop the application service.
* Connect to Postgres DB.
* Execute the below query
ALTER USER postgres WITH PASSWORD ‘postgres’;
* Start t…

Hard Coding the Timezone in wrapper.conf and run.bat

Add an additional attribute as below in the wrapper.conf file

wrapper.java.additional.26=-Duser.timezone=Australia/Sydney

Australia/Sydney: Time zone of the customer

 

Add an additional attribute as below in the run.bat …

Issue deleting OU’s

While importing users from Active Directory sometimes OU’s wont get populated. In such scenarios connect to the database and execute the below query,
delete from adorganizationalunits;
While executing the above query sometime…

ISSUE WHILE MIGRATING MYSQL DATA OVER MSSQL.

ISSUE DESCRIPTION: 

When restoring MYSQL data in MSSQL database getting error like “Violation of UNIQUE KEY Constraint (table name). Cannot insert duplicate key in the object”

 0

In the above case  Asset->Software-&g

ISSUE WHILE MIGRATING MYSQL DATA OVER MSSQL.

ISSUE DESCRIPTION:  When restoring MYSQL data in MSSQL database getting error like Java.sql.BatchupdateException: Violation of UNIQUE KEY Constraint ‘usersitemapping_UK’. Cannot insert duplicate key in object &#8

Duplicate entry while restoring data

Cause:

When inserting a word in mssql with trailing space like “service desk”, the word is inserted as it is. However, when inserting the same word in mysql, the word “service desk ” is trimmed as “serviced

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500