Month: November 2024

Oracle Error ORA-19196: XMLType table or view is not allowed with this form of fn:collection

Oracle Error ORA-02815: Unable to attach shared memory

Oracle Error ORA-02822: Invalid block offset

Oracle Error ORA-01341: LogMiner out-of-memory

Oracle Error ORA-29302: database is not open clone

Check for Weekend in Microsoft Excel

How to Check for Weekend in Microsoft Excel ?

Oracle Error ORA-01417: a table may be outer joined to at most one other table

SQL Server Error Msg 7996 – Extended stored procedures can only be created in the master database.

DB2 Error Code – -678 the literal literal specified for the index limit key must conform to the data type data type of the corresponding column column name

Oracle Error PLS-01473: Use <> instead of != or ~=

Oracle Error QSM-01109: while rewriting with MV, string, table, string, migrated to query delta

C# Error CS0743 – Expected contextual keyword ‘on’

Sybase Error – Geometry expressions cannot be used in the ORDER BY specification (near ‘%1’)

MySQL Error MY-011700 – ER_GRP_RPL_FAILED_TO_INIT_APPLIER_HANDLER

SQL Server Error Msg 21082 – Database property ‘IsRecursiveTriggersEnabled’ has to be false for subscription databases at Subscribers that allow updatable subscriptions.

Oracle Error ORA-01406: fetched column value was truncated

SQL Server Error Msg 21581 – Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of  2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article has a join filter with a join_unique_key value of 0. Either select a value of 0 or 1 for the @partition_options parameter, or use sp_changemergefilter to specify a value of 1 for join_unique_key.

How to Find the Path to the C# Compiler in Visual Studio Command Prompt ?

SQL Server Error Msg 45172 – The ‘MaximumLag’ parameter requires that ‘IsContinuous’ is specified.

SQL Server Error Msg 14693 – A collection set cannot start without a schedule. Specify a schedule for the collection set.