MapInfo Pro

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hi Rui

What statement gets executed around these lines?

A couple of suggestions:

1. In a tool, try to select into named queries where ever possible:

Select * From SomeTable Into __Temp__Result

2. In a tool, select using NoSelect unless you need the selection/highlightning:

Select * From SomeTable Into __Temp__Result NoSelect

3. In a tool, select using Hide to avoid showing the temp query in the Table List:

Select * From SomeTable Into __Temp__Result NoSelect Hide

These suggestions will result in fewer temp files being created, and will also speed up your tool running in 64-bit MapInfo Pro

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hi, Peter,

Thank you very much for your suggestions.

They are all "select" queries for the lines getting errors, and some of them are selecting from base table instead of queries. Whenever tool stops  due to that issue, I run the select query from error lines in Mapinfo's mapbasic and they are all working fine. What is more confusing is that this is completely random, it is not failing on a specific lines, changes every time (and sometimes (around 20% of time) even complete running without issues).

I did follow No.1 and No.2 when building my tool. I have just not used "hide" yet. 

I did try putting in some "hide" command for part of select queries, but I did notice I still got one error for the line that satisfies all three points you suggested.

Any other advises on this matter, please?

Thank you.

Rui

Hi Rui

What statement gets executed around these lines?

A couple of suggestions:

1. In a tool, try to select into named queries where ever possible:

Select * From SomeTable Into __Temp__Result

2. In a tool, select using NoSelect unless you need the selection/highlightning:

Select * From SomeTable Into __Temp__Result NoSelect

3. In a tool, select using Hide to avoid showing the temp query in the Table List:

Select * From SomeTable Into __Temp__Result NoSelect Hide

These suggestions will result in fewer temp files being created, and will also speed up your tool running in 64-bit MapInfo Pro

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hi

Can you try to share the statements around the statement that fails?

Maybe the two statements before and the two after. I just want to get an understanding of what you are doing with the query result.

Also, you can try to restart MapInfo Pro and see if that helps. It should make MapInfo Pro create a new temp folder under %TEMP%\MIPRO for the new session and so making sure you don't have a bunch of old query tables in the folder.

Hi, Peter,

Thank you very much for your suggestions.

They are all "select" queries for the lines getting errors, and some of them are selecting from base table instead of queries. Whenever tool stops  due to that issue, I run the select query from error lines in Mapinfo's mapbasic and they are all working fine. What is more confusing is that this is completely random, it is not failing on a specific lines, changes every time (and sometimes (around 20% of time) even complete running without issues).

I did follow No.1 and No.2 when building my tool. I have just not used "hide" yet. 

I did try putting in some "hide" command for part of select queries, but I did notice I still got one error for the line that satisfies all three points you suggested.

Any other advises on this matter, please?

Thank you.

Rui

Hi Rui

What statement gets executed around these lines?

A couple of suggestions:

1. In a tool, try to select into named queries where ever possible:

Select * From SomeTable Into __Temp__Result

2. In a tool, select using NoSelect unless you need the selection/highlightning:

Select * From SomeTable Into __Temp__Result NoSelect

3. In a tool, select using Hide to avoid showing the temp query in the Table List:

Select * From SomeTable Into __Temp__Result NoSelect Hide

These suggestions will result in fewer temp files being created, and will also speed up your tool running in 64-bit MapInfo Pro

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hi Riu

Were you able to resolve your issue by using the session dependable temp folder instead of the general MIPRO temp folder?

Hi

Can you try to share the statements around the statement that fails?

Maybe the two statements before and the two after. I just want to get an understanding of what you are doing with the query result.

Also, you can try to restart MapInfo Pro and see if that helps. It should make MapInfo Pro create a new temp folder under %TEMP%\MIPRO for the new session and so making sure you don't have a bunch of old query tables in the folder.

Hi, Peter,

Thank you very much for your suggestions.

They are all "select" queries for the lines getting errors, and some of them are selecting from base table instead of queries. Whenever tool stops  due to that issue, I run the select query from error lines in Mapinfo's mapbasic and they are all working fine. What is more confusing is that this is completely random, it is not failing on a specific lines, changes every time (and sometimes (around 20% of time) even complete running without issues).

I did follow No.1 and No.2 when building my tool. I have just not used "hide" yet. 

I did try putting in some "hide" command for part of select queries, but I did notice I still got one error for the line that satisfies all three points you suggested.

Any other advises on this matter, please?

Thank you.

Rui

Hi Rui

What statement gets executed around these lines?

A couple of suggestions:

1. In a tool, try to select into named queries where ever possible:

Select * From SomeTable Into __Temp__Result

2. In a tool, select using NoSelect unless you need the selection/highlightning:

Select * From SomeTable Into __Temp__Result NoSelect

3. In a tool, select using Hide to avoid showing the temp query in the Table List:

Select * From SomeTable Into __Temp__Result NoSelect Hide

These suggestions will result in fewer temp files being created, and will also speed up your tool running in 64-bit MapInfo Pro

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hi, Peter,

Thank you for following up, I have applied your recommended settings, however the issue is still popping up randomly. I assume it is still to do with maybe antivirus and is now contacting IT trying to resolve the issue.

Please let me know if you have any other thoughts.

Thank you.

Regards,

Rui Xu

Hi Riu

Were you able to resolve your issue by using the session dependable temp folder instead of the general MIPRO temp folder?

Hi

Can you try to share the statements around the statement that fails?

Maybe the two statements before and the two after. I just want to get an understanding of what you are doing with the query result.

Also, you can try to restart MapInfo Pro and see if that helps. It should make MapInfo Pro create a new temp folder under %TEMP%\MIPRO for the new session and so making sure you don't have a bunch of old query tables in the folder.

Hi, Peter,

Thank you very much for your suggestions.

They are all "select" queries for the lines getting errors, and some of them are selecting from base table instead of queries. Whenever tool stops  due to that issue, I run the select query from error lines in Mapinfo's mapbasic and they are all working fine. What is more confusing is that this is completely random, it is not failing on a specific lines, changes every time (and sometimes (around 20% of time) even complete running without issues).

I did follow No.1 and No.2 when building my tool. I have just not used "hide" yet. 

I did try putting in some "hide" command for part of select queries, but I did notice I still got one error for the line that satisfies all three points you suggested.

Any other advises on this matter, please?

Thank you.

Rui

Hi Rui

What statement gets executed around these lines?

A couple of suggestions:

1. In a tool, try to select into named queries where ever possible:

Select * From SomeTable Into __Temp__Result

2. In a tool, select using NoSelect unless you need the selection/highlightning:

Select * From SomeTable Into __Temp__Result NoSelect

3. In a tool, select using Hide to avoid showing the temp query in the Table List:

Select * From SomeTable Into __Temp__Result NoSelect Hide

These suggestions will result in fewer temp files being created, and will also speed up your tool running in 64-bit MapInfo Pro

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

When your tool stops working with that error, can you check if you have many temp files in the temp folder you are using?

Maybe that can tell us if the issue is too many temp files or if it's something else causing this

Hi, Peter,

Thank you for following up, I have applied your recommended settings, however the issue is still popping up randomly. I assume it is still to do with maybe antivirus and is now contacting IT trying to resolve the issue.

Please let me know if you have any other thoughts.

Thank you.

Regards,

Rui Xu

Hi Riu

Were you able to resolve your issue by using the session dependable temp folder instead of the general MIPRO temp folder?

Hi

Can you try to share the statements around the statement that fails?

Maybe the two statements before and the two after. I just want to get an understanding of what you are doing with the query result.

Also, you can try to restart MapInfo Pro and see if that helps. It should make MapInfo Pro create a new temp folder under %TEMP%\MIPRO for the new session and so making sure you don't have a bunch of old query tables in the folder.

Hi, Peter,

Thank you very much for your suggestions.

They are all "select" queries for the lines getting errors, and some of them are selecting from base table instead of queries. Whenever tool stops  due to that issue, I run the select query from error lines in Mapinfo's mapbasic and they are all working fine. What is more confusing is that this is completely random, it is not failing on a specific lines, changes every time (and sometimes (around 20% of time) even complete running without issues).

I did follow No.1 and No.2 when building my tool. I have just not used "hide" yet. 

I did try putting in some "hide" command for part of select queries, but I did notice I still got one error for the line that satisfies all three points you suggested.

Any other advises on this matter, please?

Thank you.

Rui

Hi Rui

What statement gets executed around these lines?

A couple of suggestions:

1. In a tool, try to select into named queries where ever possible:

Select * From SomeTable Into __Temp__Result

2. In a tool, select using NoSelect unless you need the selection/highlightning:

Select * From SomeTable Into __Temp__Result NoSelect

3. In a tool, select using Hide to avoid showing the temp query in the Table List:

Select * From SomeTable Into __Temp__Result NoSelect Hide

These suggestions will result in fewer temp files being created, and will also speed up your tool running in 64-bit MapInfo Pro

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hello Rui,

Do you have anitvirus software running scanning any newly created file on your computer?  If yes, then add the directory to excluded list. 

I had to do this; otherwise, my mapbasic programs would stop with this same error message and it was always random when it would happen.

the issue was MapInfo Pro was racing my antivirus software scan when the newly created temp files got created by Pro.

Hope this maybe helps fix the issue.

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui

Hello Rui,

Do you have anitvirus software running scanning any newly created file on your computer?  If yes, then add the directory to excluded list. 

I had to do this; otherwise, my mapbasic programs would stop with this same error message and it was always random when it would happen.

the issue was MapInfo Pro was racing my antivirus software scan when the newly created temp files got created by Pro.

Hope this maybe helps fix the issue.

Hi, all,

I have been facing an issue where mapinfo cannot access mapXXXX.tmp files which results in my script to stop working. The issue is happening randomly (sometimes it runs through without issue) and it happens to random select query within the script. the error message as per below:

1st run fails at Line 966

2nd run fails at line 990

It has been happening for the last month, anyone has any idea on why this is happening and how to resolve it?

Thank you.

Rui