SYMPTOM:
While trying to create a project through the Project Wizard or Project Builder in Strategy Developer 9.x - 10.x, the following error appears:
The schema is locked by. The project schema cannot be modified
The DSSerros log shows the following message:
Database error <>: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Cannot use Memo, OLE, or Hyperlink Object field `PROP_VAL` in the SELECT clause of a union query.
%1 object `%2` with ID `%3` cannot be modified because it is %4 by `%5` on `%6` since %7. Please contact your administrator for more information.
CAUSE:
The issue occurs when using a Microsoft Access Metadata. The issue is due to incompatibility with the Microsoft Jet 4.0 service pack installed.
ACTION:
To resolve this problem, install the latest Microsoft Jet 4.0 service pack. For additional information about how to obtain and how to install the latest Jet 4.0 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
How to obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
WARNING:
This technical note contains a link to a third party website that is not under the control of Strategy. When the user accesses a third party web site, the user does so at his or her own risk and acknowledges that Strategy is not responsible or liable for any content, advertising, products or other materials available from such third party sites. Mention of third party companies and web sites in this technical note is for informational purposes only and does not constitute an endorsement or recommendation.
