Sage X3 - Remove Folder


Remove folder from Sage X3

Remove folder in Sage X3 folder. Go to Setup > General Parameters > Folders.
Delete the unused folder.


Manual remove all tables, views and sequences in SQL by running the queries below to get all the drop queries of tables, views and sequences.

Select 'DROP VIEW ' + TABLE_SCHEMA + '.[' + TABLE_NAME+']' from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA in ('FOLDER')

Select 'DROP TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME+']' from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA in ('FOLDER')

Select 'DROP SEQUENCE  ' + SEQUENCE_SCHEMA + '.[' + SEQUENCE_NAME+']' from INFORMATION_SCHEMA.SEQUENCES WHERE SEQUENCE_SCHEMA in ('FOLDER')


Execute Drop queries from VIEW, TABLE and SEQUENCE.

Once done, run the queries below to remove user/schema/login.

Drop Schema FOLDER
Drop User FOLDER
Drop User FOLDER_REPORT

DROP LOGIN FOLDER
DROP LOGIN FOLDER_REPORT

Last step, manual remove the physical folder in directory below.

folders\FOLDER 
folders\X3_PUB\FOLDER







Comments

Post a Comment

Popular posts from this blog

Sage X3 - Install and configure SMTP in IIS 6 by using gmail account

Image
Install and Configure SMTP in IIS 6 by using GMAIL Account You can use your gmail as relay server to allow email to be sending out from X3 workflow. To enable it, you need to turn on 'Allow less secure apps' in your gmail account setting. In order to use SMTP relay server Windows Server 2012 , you need to enable SMTP server and Telnet Client in Add roles and features wizard. Once SMTP installed, go to IIS6.0 Manager, select the IP Address. Go to Delivery tab, click on outbound security button. Enter your gmail account and password. Tick TLS encrytion.  On same Delivery tab, click on outbound connection button, change the port to 587.  Click on Advance button, change the smart host to smtp.gmail.com. You may reset IIS and start SMTP virtual server once it's done. To use Sage X3 workflow emailing, you have to login X3, set up parameters value, configure workflow rules and user assignment. Go to parameter values, select S
Read more

Sage X3 - Regenerate Syracuse Certificate

Image
There are some of the reasons that you need to regenerate Sage X3 Syracuse certificate, the reasons could be: 1. Expired of certificate 2. Uninstall or re-install of X3 Syracuse 3. Changes of server information 4. Incomplete, corrupted or missing of information in Certificate 5. Changes of password of SageRT (Granted administrator user running X3 services) The possible error below that you encountered below might required regenerate the certificate in order for you able to login Sage X3 again. 1. Cannot read passphrase file. Maybe it has been created under another operating user. 2. Error connect ECONNREFUSED. Here are the steps to regenerate certificate for Syracuse: 1. Go to Syracuse installation directory, <Syracuse>\syracuse\cert_tools. Make backup of output folder by rename it.Click on certgen.bat, this will open a command prompt. 2. Fill in all necessary information for Country, State, City, Organization, Organization Unit, Name and Va
Read more

Sage X3 - Add a new custom field in Journal Entry

Image
Add a new custom field in Journal Entry This is to show  how you can add a new c u stom field in journal entry.  Add new field in GACCENTRTYD table.  Add this new field to screens GACCENT2, GACCENTR1, GACCENTR3, GACCENTW as below. Save and click validation for those screen with validation button enabled.  GACCENT2 screen, (HAE2) GACCENTR1 screen, (XAE1) GACCENTR3 screen (HAE2)  GACCENTW screen (HAEW) Global Validation on the windows - OGAS & OGGSTD for the object GAS Go to  Journal Entry Transaction  (under Setup –> Financials –> Journal entry transactions). Make the changes and save the record as below. Logout & Login to test the changes.
Read more