NO ROWS Function ‘rs_get_textptr’ for ‘sometable’ returned no rows, table example:- create table test_tab( cola int not null, colb_txt text null) This occurs with columns containing text columns. The problem is you forgot sp_setrepcol. The default for text/image is always replicate and so not null is assumed. So you need to run sp_setrepcol to set […]
Audience: Managers/Non-database technical staff/RDBMS (database server) Beginners. Sometimes an application can misbehave. It is normal for processes inside an RDBMS system to occasionally get blocked by another process which is currently updating data, and this normally goes unnoticed as it is usually short-lived and clears once the update activity finishes and the locks are released. However, sometimes […]
Why should different version of Sybase on a single Windows server be an issue? If you install multiple versions of Sybase ASE, the paths will become filled with contradictory references to both Sybase install locations. The Windows servers may or may not start but even if they do, you cannot be 100% sure which library […]
Our SAP Sybase Replication servers sometimes suddenly start using unexpectedly high amount of stable queue. So I wrote this short script to check the size of the stable queue usage and send an alert if any the % usages is greater than the value of $ALERT_PERCENT. Then when a user starts running a massive batch […]
Since 15.7 sp1xx there has been a great new facility to increase and decrease log segments in an ASE database but did you know that you could end up with a row in the sysusages table that you cannot get rid of? Further research shows this to be a know issue with the use of […]
