Tuesday, August 29, 2017

Web compatibility check: Query errors

Web compatibility check: Query errors

This article lists Query errors that you may encounter when you run the Compatibility Checker, and provides information that can help you resolve the errors.

For general information about Compatibility Checker errors, see the article Web compatibility check General errors.

ACCWeb102012

ACCWeb102014

ACCWeb103013

ACCWeb103079

ACCWeb103900

ACCWeb103901

ACCWeb103902

ACCWeb103903

ACCWeb103904

ACCWeb103905

ACCWeb103906

ACCWeb103907

ACCWeb103908

ACCWeb103916

ACCWeb103918

ACCWeb103926

ACCWeb103927

ACCWeb103928

ACCWeb103930

ACCWeb103938

ACCWeb103939

ACCWeb103940

ACCWeb103942

ACCWeb102012

Error text    The Query is incompatible with the Web.

What it means    You must check for Web compatibility issues in the query.

What to do    Recreate the query by using the query designer. For more information about how to use the query designer to create a web query, see Introduction to queries.

Top of Page

ACCWeb102014

Error text    The SQL is incompatible with the Web.

What it means    There can be many reasons why you would receive this error. You may be doing one of the following:

  • Referencing web incompatible objects.

  • Referencing web incompatible expressions.

For more information about how to create expressions, see Create an expression.

What to do     Consider using the web query designer to create queries that are web compatible. For more information on designing queries for the Web, see Introduction to queries.

Top of Page

ACCWeb103013

Error text    Access was unable to convert the query for use on the Web because the query results contain multiple fields that have the same name.

What it means    Multiple fields have the same name.

What to do    Check for duplicate field names and change the duplicates to distinct field names.

Top of Page

ACCWeb103079

Error text    Type mismatch in expression.

What it means    The types on either side of the join are incompatible or the field types compared are incompatible types. For example, text to number cannot be compared or joined.

What to do    Ensure that the side of the joins are compatible. For example, join text type to text type and number type to number type. If you are not performing a join, check if you are comparing incompatible field types.

Top of Page

ACCWeb103900

Error text    Access was unable to convert the query for use on the Web.

What it means    Access was unable to publish the query because it uses an unsupported query type, unsupported expressions, unsupported criteria, or other features that are not supported on the Web.

What to do    Use the Access query designer to redesign the query.

Top of Page

ACCWeb103901

Error text    The definition of the query is invalid, so that the query object cannot be created.

What it means    The server was unable to parse the query because of an unexpected error in the query definition.

What to do    Use Access designers to redesign the query.

Top of Page

ACCWeb103902

Error text    Access was unable to convert the query for use on the Web because it uses an unsupported query type, unsupported expressions, unsupported criteria, or other features that are not supported on the Web.

What it means    The query contains expressions that are incompatible with the Web. This error can occur either because of a server restriction or when an expression cannot move to the server.

What to do    Remove the expressions that are not web compatible. For more information on expressions are valid on queries see Create an expression.

Top of Page

ACCWeb103903

Error text    The definition of the query is invalid, so that the query object cannot be created.

What it means    One of the attribute values is incompatible with the Web.

What to do    Ensure that the following conditions are set correctly:

  • The name attribute does not have any of the following:

Equal sign at the beginning

=

Period

.

Exclamation mark

!

Square brackets

[]

Blank leading space

Non-printable characters

For example: <Enter> or <TAB>

Any of the following symbols

/ \ : * ? " < > | # { } % ~ &

  • The name attribute is between one and 64 characters long.

  • Caption attribute: Any string, up to 1024 characters.

Top of Page

ACCWeb103904

Error text    Access was unable to convert the query for use on the Web because it contains a sub-query.

What it means    The query contains a subquery. Subqueries are not supported on the server.

What to do    Modify your query so that it does not have a sub query.

Top of Page

ACCWeb103905

Error text    Access was unable to convert the query for use on the Web because it relies on a different query that is not Web compatible.

What it means    The query either contains a nested query as a input that cannot be represented on the server or it contains an input source that cannot be found.

What to do    

  • Ensure that the nested query is valid.

  • Use Access query designers to create a valid nested query.

  • Ensure that the query input source table or query exists in the database.

Top of Page

ACCWeb103906

Error text    The definition of the query is invalid, so that the query object cannot be created.

What it means    The source table or query of the selected or order by columns cannot be found.

What to do    Ensure that the column input source table or query exists in your Access database.

Top of Page

ACCWeb103907

Error text     Access was unable to convert the query for use on the Web because it does not include any fields in its results.

What it means    No columns are selected in the query.

What to do    Select or specify at least one output column in the query.

Top of Page

ACCWeb103908

Error text     Access was unable to convert the query for use on the Web because it displays too many fields in its results.

What this means     The query source has too many columns.

What to do     This may be difficult to resolve and you might have to examine the source tables. A table can have no more than:

  • JET_ccolFixedMost fixed columns.

  • JET_ccolVarMost variable-length columns.

  • JET_ccolTaggedMost tagged columns.

Top of Page

ACCWeb103916

Error text    Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web..

What this means    One or more of the following conditions exists:

  • Name of an order by element is not valid.

  • Name of source table is not valid.

  • Sort order is set to an option other than ascending or descending.

  • The expression is not valid.

What to do    Ensure that the following conditions are set correctly:

  • The name attribute does not contain any of the following:

Equal sign at the beginning

=

Period

.

Exclamation mark

!

Square brackets

[]

Blank leading space

Non-printable characters

For example: <Enter> or <TAB>

Any of the following symbols

/ \ : * ? " < > | # { } % ~ &

  • The name attribute is between one and 64 characters long.

  • The expression is a valid expression.

Top of Page

ACCWeb103918

Error text     Access was unable to convert the query for use on the Web because it specifies a JOIN type that is not supported on the Web.

What it means    The server does not support queries that have multiple joins between two tables (multi-field joins).

What to do    Ensure that the joins use only one field per table.

Top of Page

ACCWeb103926

Error test    Access was unable to convert the query for use on the Web because it does not specify which table to SELECT FROM.

What it means     The query has no input tables (missing the FROM clause).

What to do    Ensure that your query has an input column specified.

Top of Page

ACCWeb103927

Error text    Access was unable to convert the query for use on the Web because the query results contain multiple fields that have the same name.

What it means    You specified the same name for multiple fields.

What to do    Check for duplicate field names and change the duplicates to distinct field names.

Top of Page

ACCWeb103928

Error text    Access was unable to convert the query for use on the Web because some of its parameters could not be converted for use on the Web.

What it means    The parameter name or type is not valid.

What to do    Ensure that the parameter name and type are valid.

  • The name attribute has does not contain:

Equal sign at the beginning

=

Period

.

Exclamation mark

!

Square brackets

[]

Blank leading space

Non-printable characters

For example: <Enter> or <TAB>

Any of the following symbols

/ \ : * ? " < > | # { } % ~ &

  • The name attribute is between one and 64 characters long.

The following types are valid:

Text (up to 255 characters)

Numbers

Boolean

DateTime

Currency

Top of Page

ACCWeb103930

Error text    Access was unable to convert the query for use on the Web because some of its parameters are displayed as result fields or used in ORDER BY statements.

What it means    The query has a parameter that is either projected as a scalar or used in an order by statement.

This can occur if a parameter is used either as a projected column (Example: select param1 from Table1) or as order by (Example: select * from table 1 and order by field1= param).

What to do    Avoid using parameters that are projected column or order by column.

Top of Page

ACCWeb103938

Error text    Access was unable to convert the query for use on the Web.

What it means    There are two fields that have same name and Access is unable to create valid aliases for them.

What to do    Check for duplicate field names and change the duplicates to distinct field names.

Top of Page

ACCWeb103939

Error text    Access was unable to convert the query for use on the Web.

What it means    The query has an alias that is greater than 64 characters.

What to do    Ensure the alias used in the query is less than or equal to 64 characters.

Top of Page

ACCWeb103940

Error text    Access was unable to convert the query for use on the Web because it specifies a JOIN type that is not supported on the Web.

What it means    The server does not support queries that have multiple joins on the same two tables (multi-field joins).

What to do    Ensure that the joins you are using only one field per table.

Top of Page

ACCWeb103942

Error text     Access was unable to convert the query for use on the Web because it contains a cyclical join.

What it means    The joins between the tables in your query are causing a circular join between the tables which is preventing Access from converting the query for use on the Web.

What to do     Remove joins between tables so that the cyclical joins are removed.

Top of Page

No comments:

Post a Comment