Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
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 Email Submit and Notelogger doesn't work in SBM 11 if you start with a brand new database ( Not sample db )
To workaround run the following sql queries against the Application Engine database. Update TS_ LASTIDS set TS_ LASTID =2 where TS_TABLEID = 230 Insert TS_MAILSUBMITREGISTRY values (1, null, 0);
CMS-XML Smart Search indexing does not complete for certain tables.
INFO 09-01-2014 09:35:16 [IndexerProcess] -- Start index creation for table USR_TEST(1000) DEBUG 09-01-2014 09:35:16 [IndexerServiceImpl] -- GetNextItems tableId: 1000 lastId : 0 returned 16 Items in 13 millis. INFO 09-01-2014 09:35:16 [IndexerProcess] -- Indexer process 80 finished(time: 0 secs)
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 SBM 11.3 upgrade fails with ORA-04080 error
drop trigger TRG_CP_TO_REL_CHANGEACTIONS drop trigger TRG_CP_TO_REL_ADMINCHANGES drop procedure PRC_UPDATE_ LASTID
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 SRC - Request Center has strange characters on welcome banner or the locale not being shown intermittantly
declare @settingsId int; update TS_ LASTIDS set TS_ LASTID =TS_ LASTID +1 where TS_TABLEID=56 select @settingsId = TS_LASTID from TS_LASTIDS where TS_TABLEID=56
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 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;
CMS-XML How to add Headers and Footers to the SBM Work Center (SBM 11.x example - Creating Classification/Alert Banners for SBM)
If no row was returned, you will need create add the row by following these steps: Increase the LASTID value using this command: update TS_LASTIDS set TS_LASTID=TS_LASTID+1 where TS_NAME = 'SystemSettings'

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs