Data migration from MongoDB to PostgreSQL in Pega Chat
We have upgraded Pega Chat from v7.22.5 to v7.4 hence would like migrate data from MongoDB to Postgres as MongoDB is no longer supported in v7.4. In the process of migration, i am encountering errors like cannot find module colors/safe, uuid. I think colors module is needed just to give color to output but not sure on the need for uuid. We donot have internet access from servers to install these modules from npm. Is there a way that data migration can be performed without these modules or any other alternative?
***Edited by Moderator: Pallavi to update platform capability tags***
Accepted Solution
Pegasystems Inc.
US
Upon reviewing the associated Support Request, this was resolved by referencing the correct schema while querying the data.
Pegasystems Inc.
US
Hi, @RamyaG92 - Good to hear that you're migrating to a more recent version of the Pega Chat server! Not having internet access for installing the modules definitely brings challenges. I'm not sure what alternatives there may be, but I'll see if the chat engineers have any suggestions.
Pegasystems Inc.
IN
Hi @RamyaG92 ,
Please run npm install on an similar instance which has internet access ,post that zip the node_modules folder and copy it to the instance on which you wish to run the migration code.
Further delete the existing node_modules folder in the directory and unzip the copied node_modules zip file.
Accenture
IN
Hi,
I have tried npm install in db-migrations folder. node_modules folder got created. Then when i perform data migration by executing "node index.js", i can see data migration got completed but see an validation error. Attached screenshot. Could you please help me in resolving it.
Accepted Solution
Pegasystems Inc.
US
Upon reviewing the associated Support Request, this was resolved by referencing the correct schema while querying the data.