Announcements

Announcement: We’re aware of an issue affecting starting a new topic from category pages and creating new blog posts. New topics can still be started directly from the relevant board. Learn more here.

"Column 'PI y' does not belong to table" Error

"Column 'PI y' does not belong to table" Error

ekoneo
Advocate Advocate
1,593 Views
10 Replies
Message 1 of 11

"Column 'PI y' does not belong to table" Error

ekoneo
Advocate
Advocate

Hi,

 

I get "Column 'PI y' does not belong to table" error when I am exporting some feauturelines that are created from corridor, as leica infrastructure .xml file. Normally I can transfer corridor featurelines however, if the corridor's aligment has a spline I get this kind of error. Anybody has any suggestion?

 

Thanks.ExportError.pngExportError.png

0 Likes
1,594 Views
10 Replies
Replies (10)
Message 2 of 11

tcorey
Mentor
Mentor

I suggest you don't use splines in alignments. How do you even get an alignment to accept a spline as a sub-entity?

 

Or did you mean spiral?



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Platinum Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
0 Likes
Message 3 of 11

ekoneo
Advocate
Advocate

Sory tcorey

0 Likes
Message 4 of 11

tcorey
Mentor
Mentor

In that case, you should consider contacting Leica support, as this is their command.



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Platinum Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
0 Likes
Message 5 of 11

ekoneo
Advocate
Advocate

I already asked Leica. But they didnt reply me about this situation.

 

Thanks a lot Tcorey.

0 Likes
Message 6 of 11

tcorey
Mentor
Mentor

My guess is that the error lies in the definition of the table ANA_6. It appears that the export routine is trying to output the coordinates as separate values. X and Y would each populate its own variable. Maybe the table is defined such that it expect X and Y as a single variable, a list of the two coordinates. Try to find the .xls file that defines the ANA_6 table. That might hold further clues.

 

I might be able to help more, but I will need you to click the Details button and then post the screenshot. 



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Platinum Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
Message 7 of 11

ekoneo
Advocate
Advocate

I serched in xml. But I couldnt find anything that can cause something.

 

I atached a photo of xml icludings.

 

Thanks.AligmentXML_Photo.pngAligmentXML_Photo.png

0 Likes
Message 8 of 11

tcorey
Mentor
Mentor

It might be in an xls file.



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Platinum Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
0 Likes
Message 9 of 11

ekoneo
Advocate
Advocate

Thanks.. Now I attached .xls file.

0 Likes
Message 10 of 11

tcorey
Mentor
Mentor

I am unable to find anything in your .xlsx file that will help us pin down the error. Sorry.



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Platinum Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
Message 11 of 11

ekoneo
Advocate
Advocate

Thanks a lot for your attention and effort. Smiley Wink

0 Likes