How do i See the log in Online ?

This seems like a bug in Gen 9 and has happened to me a few times now. 

I have a table called y_cat_req_junction which has 2 field. 1 is a relation to ticket and the second is relation to an extratable. 
After creating the table and populating it with some values I tried to group by a field, and now I cant see anything when I click on the table. I can add values to it by CRMScript and make selections on the table but not see it...

 

Also, if I try to create a new entry in an underlying related table which only has 1 field, that field wont show when creating a new entry.

RE: How do i See the log in Online ?

Hi,

Could you please send me a package with your extratables/fields for debugging purpose ?

 

Von: Michel Krohn-Dale 3. Aug 2020

RE: How do i See the log in Online ?

Hei Michel. 

Below is the extratable package with some data: 

You can reproduce the error by grouping by the foreign key feilds (main category.name) in sub category or ticket relation tables.

<?xml version="1.0" encoding="UTF-8"?>
<ejpackage> 
<name>
Package with extratables for debugging.
</name>
<packageversion>
1.0
</packageversion>
<ejversion>
9.1.0
</ejversion>
<locked>
0
</locked>
<description>
Package with extratables for debugging.
</description>
<installscript>
#setLanguageLevel 3;
</installscript>
<item index="1" domain="6" refname="" >
<name>Main category</name>
<description></description>
<tablename>y_main_category</tablename>
<flags>8</flags>
<sortorder>y_main_category.x_main_task asc</sortorder>
<searchheader>Søk</searchheader>
<viewentryheader>Vis</viewentryheader>
<newentryheader>Ny</newentryheader>
<editentryheader>Rediger</editentryheader>
<folder>NSP - Tables/</folder>
</item>
<item index="2" domain="6" refname="" >
<name>Sub category</name>
<description></description>
<tablename>y_sub_category</tablename>
<flags>0</flags>
<sortorder>y_sub_category.x_main_category asc</sortorder>
<searchheader></searchheader>
<viewentryheader></viewentryheader>
<newentryheader></newentryheader>
<editentryheader></editentryheader>
<folder>NSP - Tables/</folder>
</item>
<item index="3" domain="6" refname="" >
<name>Category Request Link</name>
<description></description>
<tablename>y_cat_req_junction</tablename>
<flags>0</flags>
<sortorder>y_cat_req_junction.id asc</sortorder>
<searchheader>Søk</searchheader>
<viewentryheader>Vis</viewentryheader>
<newentryheader>Ny</newentryheader>
<editentryheader>Rediger</editentryheader>
<folder>NSP - Tables/</folder>
</item>
<item index="4" domain="7" refname="" >
<name>Task name</name>
<description></description>
<fieldname>x_task_name</fieldname>
<defaultvalue></defaultvalue>
<domain>16</domain>
<extratable>y_sub_category</extratable>
<flags>1089536</flags>
<orderpos>1</orderpos>
<params>defaultNow=0&#x0a;defaultActiveUser=0&#x0a;useTextarea=0&#x0a;height=3&#x0a;searchOperator=beginsWith&#x0a;</params>
<targetextratable></targetextratable>
<type>2</type>
<role></role>
</item>
<item index="5" domain="7" refname="" >
<name>Main task</name>
<description></description>
<fieldname>x_main_task</fieldname>
<defaultvalue></defaultvalue>
<domain>16</domain>
<extratable>y_main_category</extratable>
<flags>1236992</flags>
<orderpos>1</orderpos>
<params>defaultNow=0&#x0a;defaultActiveUser=0&#x0a;useTextarea=0&#x0a;height=3&#x0a;searchOperator=beginsWith&#x0a;</params>
<targetextratable></targetextratable>
<type>2</type>
<role>display</role>
</item>
<item index="6" domain="7" refname="" >
<name>Main task</name>
<description></description>
<fieldname>x_main_category</fieldname>
<defaultvalue></defaultvalue>
<domain>16</domain>
<extratable>y_sub_category</extratable>
<flags>1106944</flags>
<orderpos>2</orderpos>
<params>maxRelations=&#x0a;targetLabel=Tasks&#x0a;useDropDown=0&#x0a;onlyLeafNode=0&#x0a;defaultNow=0&#x0a;defaultActiveUser=0&#x0a;searchOperator=beginsWith&#x0a;</params>
<targetextratable>y_main_category</targetextratable>
<type>20</type>
<role></role>
</item>
<item index="7" domain="7" refname="" >
<name>Category</name>
<description></description>
<fieldname>x_category</fieldname>
<defaultvalue></defaultvalue>
<domain>16</domain>
<extratable>y_cat_req_junction</extratable>
<flags>5301248</flags>
<orderpos>1</orderpos>
<params>maxRelations=&#x0a;targetLabel=Tasks&#x0a;useDropDown=0&#x0a;onlyLeafNode=1&#x0a;defaultNow=0&#x0a;defaultActiveUser=0&#x0a;searchOperator=beginsWith&#x0a;</params>
<targetextratable>y_sub_category</targetextratable>
<type>20</type>
<role></role>
</item>
<item index="8" domain="7" refname="" >
<name>Oppdrag</name>
<description></description>
<fieldname>x_request</fieldname>
<defaultvalue></defaultvalue>
<domain>16</domain>
<extratable>y_cat_req_junction</extratable>
<flags>1303552</flags>
<orderpos>2</orderpos>
<params>maxRelations=&#x0a;targetLabel=Tasks&#x0a;defaultNow=0&#x0a;defaultActiveUser=0&#x0a;searchOperator=beginsWith&#x0a;</params>
<targetextratable></targetextratable>
<type>18</type>
<role></role>
</item>
<item index="9" domain="7" refname="" >
<name>Due date</name>
<description></description>
<fieldname>x_due_date</fieldname>
<defaultvalue></defaultvalue>
<domain>16</domain>
<extratable>y_cat_req_junction</extratable>
<flags>1105920</flags>
<orderpos>3</orderpos>
<params>defaultNow=0&#x0a;defaultActiveUser=0&#x0a;</params>
<targetextratable></targetextratable>
<type>3</type>
<role></role>
</item>
<item index="10" domain="7" refname="" >
<name>Status</name>
<description></description>
<fieldname>x_done</fieldname>
<defaultvalue>0</defaultvalue>
<domain>16</domain>
<extratable>y_cat_req_junction</extratable>
<flags>1105920</flags>
<orderpos>4</orderpos>
<params>defaultNow=0&#x0a;defaultActiveUser=0&#x0a;</params>
<targetextratable></targetextratable>
<type>6</type>
<role></role>
</item>
<item index="11" domain="8" refname="" >
<tablename>y_main_category</tablename><row></row><row></row><row></row><row></row><row></row><row></row><row></row><row></row><row></row>
</item>
<item index="12" domain="8" refname="" >
<tablename>y_sub_category</tablename><row>
<field name="x_task_name"></field>
<field name="x_main_category">71</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">72</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">73</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">74</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">75</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">76</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">77</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">78</field></row><row>
<field name="x_task_name"></field>
<field name="x_main_category">79</field></row><row>
<field name="x_task_name">Add. Terms</field>
<field name="x_main_category">71</field></row><row>
<field name="x_task_name">Appendix 1</field>
<field name="x_main_category">71</field></row><row>
<field name="x_task_name">Reach Test</field>
<field name="x_main_category">74</field></row><row>
<field name="x_task_name">Reach Declaration</field>
<field name="x_main_category">74</field></row><row>
<field name="x_task_name">CE - Certificate</field>
<field name="x_main_category">76</field></row><row>
<field name="x_task_name">Food safety</field>
<field name="x_main_category">76</field></row>
</item>
<item index="13" domain="8" refname="" >
<tablename>y_cat_req_junction</tablename><row>
<field name="x_category">131</field>
<field name="x_request">9260</field>
<field name="x_due_date">2020-07-21</field>
<field name="x_done">1</field></row><row>
<field name="x_category">123</field>
<field name="x_request">9260</field>
<field name="x_due_date">2020-07-01</field>
<field name="x_done">1</field></row><row>
<field name="x_category">128</field>
<field name="x_request">9260</field>
<field name="x_due_date">2020-07-31</field>
<field name="x_done">1</field></row><row>
<field name="x_category">134</field>
<field name="x_request">9260</field>
<field name="x_due_date">2020-07-29</field>
<field name="x_done">1</field></row><row>
<field name="x_category">133</field>
<field name="x_request">9260</field>
<field name="x_due_date">2020-07-18</field>
<field name="x_done">1</field></row><row>
<field name="x_category">129</field>
<field name="x_request">9260</field>
<field name="x_due_date">2020-07-29</field>
<field name="x_done">1</field></row>
</item>
</ejpackage>

 

 

Von: Ummair Tahir 12. Aug 2020

RE: How do i See the log in Online ?

Hi,

It seems that your column is defined as Text(long), and it is not possible to group on columns of this type unfortunately. Would suggest that you redesign it to Text(short).

For reference error produced:

NetServerException (NetServer exception: Service call Archive.GetArchiveListByColumnsWithHeader failed with exception
Archive.GetArchiveListByColumnsWithHeader

Failed to execute database command: 'SELECT T0."id", T0."dbi_agent_id", T0."x_main_category", T1."x_main_task", T1."id" FROM crm7."Y_SUB_CATEGORY" T0 LEFT OUTER JOIN crm7."Y_MAIN_CATEGORY" T1 ON (T0."x_main_category" = T1."id") ORDER BY T1."x_main_task" ASC, T0."id" ASC OPTION( RECOMPILE, FORCE ORDER )' 
On Database: 'System.Data.SqlClient.SqlConnection' 
With connection string: '*******'.' 
Parameters:

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Von: Michel Krohn-Dale 17. Aug 2020

RE: How do i See the log in Online ?

That is fine...but now i cannot see anything in the table at all...Maybe some sort of resetting profile could help ?

Von: Ummair Tahir 19. Aug 2020

RE: How do i See the log in Online ?

Hi,

Try to delete your profiles for this table under System -> Profile.

Von: Michel Krohn-Dale 19. Aug 2020

RE: How do i See the log in Online ?

Not able to go into the profile...just getting error.

SearchEngine::getTableInfo() table y_... not found.

Von: Ummair Tahir 24. Aug 2020

RE: How do i See the log in Online ?

Hi,

Seems that it has gotten corrupted somehow, suggest you contact support for assistance in deleting this specific profile from database. Every profile has an ID which should be visible in url or on hover.

Von: Michel Krohn-Dale 25. Aug 2020

RE: How do i See the log in Online ?

Hi, 

I believe I saw something like this before. My tip:

1. Create empty table with idendical name that gives error y_.....
2. Go to Profile, delete all profiles that calls to that table
3. Go back and delete that table y_...., if there is no need for it anymore.

This should do the trick. If not, please contact support.

Von: Donatas Sasnauskas 25. Aug 2020