General Consultant Discussion

What does this do? 2. Enter SYZCON in the Program field 3. At the prompt, enter the following command: O=NEW(""SY_ACTIVATION_BUS"",%SYS_SS) 4. Click the Enter key 5. At the prompt enter the following command: PRINT O'ACTIVATE(""A/R"",""xxx"") xxx = Company Code (ex. ABC) 6. Click the Enter key 1 is returned if the command was successful 0 is returned if the command failed

Larry, pretty much checks to see if the module is registered, creates appropriate tables for that module and writes out system records. If you are getting a 0 return, then you can type PRINT O'LastErrorMsg$ that will give you a brief message as to why. Hope that helps.

Larry the other thing it does is when run for existing company data, it updates the physical tables to match the dictionary. In case you're asking about this in reference to your post about the SQL database being restored that didn't contain the UDF columns, first know it's a Premium bug which @JohnnyPabian reported awhile back with UDF Maintenance / Update where after updating a certain number of company codes it just stops updating. So doing the o'Activate(""A/R"", ""ABC"") would in fact physically add back the missing UDF columns to the A/R tables (b/c it's defined in the dictionary). In the 4.early days it would also restore what was known as ""embedded IO"". E.g. back in the day there was a both a CI_Item and IM1 and sometimes you wouldn't see the item description in S/O Entry and stupid things like that. This 2-liner from Syzcon to place back the embedded IO was the fix. I have a lot of bar room arcane knowledge on embedded IO scheme, why it got invented, who put it out of its misery, and other MAS90 trivia. Besides that, this has been used to fix a variety of strange dict issues where data is not saved or a lookup doesn't behave like these: https://90minds-com.socialcast.com/messages/27661218 https://90minds-com.socialcast.com/messages/25809221 https://90minds-com.socialcast.com/messages/25069781

It is exactly related to my other post. I was told by client and staff this was run the day before I found all of the missing UDF columns in the SQL tables. I was able to add by using the listing (which I forgot was there and Jim Woodward was kind enough to remind me) and going down the list and updating each table.