Find Answers

Filter Search Results
All Products:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
  Results
CMS-XML Problems after deploy of new tables - lastids and other issues
Problems after deploy of new tables - lastids and other issues
CMS-XML Disabling Preference Warning in Application Administrator When New Users Are Added to Groups - Warning: - Group preferences are not automatically apply
To disable this warning: 1. Allocate a new TS_ID for the new Setting record by updating the TS_ LASTIDS table. UPDATE TS_LASTIDS SET TS_LASTID = TS_LASTID + 1 WHERE TS_TABLEID = 182;
CMS-XML An exception occurred while attempting to calculate the next ID number to be used for the "table" - error: Unable to get next id for tableid ... Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim
When attempting to calculate " lastid " values for AE tables, the SQL used could sometimes cause deadlocks and slowing down of the AE interface. Upgrading to 10.1.5 clears up the issue by modifying the queries used when updating tables.
CMS-XML Delayed notifications stop working and do not send
update TS_NOTIFICATIONEVENTS set TS_TIME=2000000002 /* date from distant future */ where TS_DELAYED=1 and TS_TIME=0 and TS_ID < (select TS_ LASTID - 100 from TS_ LASTIDS where TS_NAME = 'NotificationEvents');
CMS-XML Creating table in global mashup should stop you from using a system table name. Incoming table already exists
ADMINCHANGES LASTIDS URLSTORE
CMS-XML ERROR Exception Thrown while processing Notification Event ... java.lang.NullPointerException - when processing a notification on a New Database created with System Administrator (not upgraded database or sample)
DECLARE @ LASTID INT set @LASTID = (select TS_LASTID from TS_LASTIDS where TS_NAME like 'SystemSettings') + 1 INSERT INTO TS_SYSTEMSETTINGS
CMS-XML Relational field is cleared on update if defined as a Drop Down List and there are more than 10000 items
1. Allocate a new TS_ID for the new setting record by updating the TS_ LASTIDS table. UPDATE TS_LASTIDS SET TS_LASTID = TS_LASTID + 1 WHERE TS_TABLEID = 56;

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs