I am working on template project for MDM and i am not able to run the pgsql script in it and i did followed the steps mentioned in this MDM Example Project - Ataccama ONE Gen2 Platform Latest
Kindly let me know if you have any solution for this.
Solved
pgsql not working in MDM template project.
+1- Data Voyager
- 1 reply
Best answer by DannyRyan
Hi
The start-mdm-server.bat calls an external cmd (command) terminal. (External to ONE Desktop Application).
Did you observe a Command Terminal session opening at all?
If you are unable to see the “MDM Server” command terminal -- this may indicate the batch files are blocked by your companies security policy.
Are you able to run the following, which calls our encrypt.bat script
- Using your Windows Start Menu
- Type
Command - Locate and Click on Command Prompt, App.
- In Command Prompt type the location of your Ataccama build followed by
\runtime\bin\ - Based on the screen shot you provided this would be
cd c:\NEW_MDM\ataccama 14.5\runtime\bin\ - Run
encrypt.bat - Enter any text you like, I used “
Hello World!” - Press Enter
- The encrypted form of the text you entered should then be displayed.
This was a simple task, to determine if you are able to run Window Command Prompts.
If you are able to run this test and you still have trouble - i would suggest raising a ticket with your IT/Security team for them to review further.
Please let us know how you get on.
Danny
1 person likes this
+2- Head of Technical Training
- 41 replies
Hi
Would it be possible to click on the ‘Properties’ tab at the bottom of your screen.
Then share the full path of the stop-db-postgres.bat file.
Given the error message you have received, I have a theory that there are folders containing a space character in the full path.
For exampleC:\NEW FOLDER\
Windows Batch files require a change to enclosure paths in double quotes, when folders containing spaces are used.
The simplest solution is to replace the space character with another characterC:\NEW_FOLDER\
Let us know if this is the case, and if removing the space character helped to resolve the issue.
Have a great day
Danny
+1- Data Voyager
- 1 reply
Hi,
This is the full path of stop-db-postgres.bat file.
also when i try to start start-mdm-server.bat it gets terminated.
Regards,
Mayuresh
+2- Head of Technical Training
- 41 replies
- Answer
Hi
The start-mdm-server.bat calls an external cmd (command) terminal. (External to ONE Desktop Application).
Did you observe a Command Terminal session opening at all?
If you are unable to see the “MDM Server” command terminal -- this may indicate the batch files are blocked by your companies security policy.
Are you able to run the following, which calls our encrypt.bat script
- Using your Windows Start Menu
- Type
Command - Locate and Click on Command Prompt, App.
- In Command Prompt type the location of your Ataccama build followed by
\runtime\bin\ - Based on the screen shot you provided this would be
cd c:\NEW_MDM\ataccama 14.5\runtime\bin\ - Run
encrypt.bat - Enter any text you like, I used “
Hello World!” - Press Enter
- The encrypted form of the text you entered should then be displayed.
This was a simple task, to determine if you are able to run Window Command Prompts.
If you are able to run this test and you still have trouble - i would suggest raising a ticket with your IT/Security team for them to review further.
Please let us know how you get on.
Danny
Danny | Did it answer your question? Mark it as the correct answer!
1 person likes this
Reply
Most Liked this week
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.