Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies replies
    12
  • Subscribers subscribers
    169
  • Views views
    552
  • Users 0 members are here
Related
Options

Adding +25 Fields To An Existing Table

Mohammad Alsharayri

Hi All !

I am adding about 25 fields to an existing table with 600K records in PROD, some of the new fields have a default value, so I tried to deploy the latest changes to PROD, but the deployment was aborted, after I checked with our DBA they said it was aborted while the SQL server trying to add the fields and update the default value of the new fields.


Did anyone get this problem? Is anyone familiar with such a problem?


Thanks! 

Parents Reply Children
  • 0 in reply to 

    It may time-out.  You may or may not get an error or other indication.

    There are several "timeout" settings you can modify or add to SBM to help with this kind of deployment issue.  Some of these settings are documented in the on-line KB; others are not documented.  For those you will have to contact tech support or the gurus like Vickie or David via PM.

  • 0   in reply to 

    If there is nothing after this message indicating activity then we will need to investigate further.  Since this message, how long has it been?  Was IIS restarted?  An IIS restart would terminate the deploy/promote though the repo would not be updated.  Compare the Event Log for "SBM Web Service" entries that may indicate something occurring after this message.

    At this point, I would expect the 6-Jun deploy to be done or failed.  If you do not see anything in the Event Log for web services then try to IISRESET, increase logging of Acitive Diagnostics for Deploy/Promote and try again.  If we do not get any response in any of these logs after an hour, create a dump of the IIS Worker Process for gsoap and create a case.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.