Solved

pgsql not working in MDM template project.

  • 30 November 2023
  • 3 replies
  • 57 views
M
Badge +1

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.

 

 

 

icon

Best answer by DannyRyan 1 December 2023, 12:02

View original
1 Attachment

3 replies

DannyRyan
Rank
Userlevel 5
Badge +9

Hi @Mayuresh 
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 example
C:\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 character
C:\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

Danny | Did it answer your question? Mark it as the correct answer!
M
Badge +1

Hi, @DannyRyan

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

DannyRyan
Rank
Userlevel 5
Badge +9

Hi @Mayuresh 

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

  1. Using your Windows Start Menu
  2. Type Command
  3. Locate and Click on Command Prompt, App.
  4. In Command Prompt type the location of your Ataccama build followed by \runtime\bin\
  5. Based on the screen shot you provided this would be cd c:\NEW_MDM\ataccama 14.5\runtime\bin\
  6. Run encrypt.bat
  7. Enter any text you like, I used “Hello World!”
  8. Press Enter
  9. 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
 

Where you able to see a window like this open up?
Quick test, running encrypt.bat to check if user can run batch files.

 

Danny | Did it answer your question? Mark it as the correct answer!

Reply


Community Terms of Use & ConditionsCookie settings