Data Standard Check Tool_v1.33 How to fix error “There is not enough memory”

Data standard inspection tool_1.Overview In the article, we explained how to use the Data Standard Check Tool_v1.33. Write down how to resolve the out of memory error in this version.


On 2022-08-18, the following error occurred in Data Standard Check Tool_v1.33.

  • &H8000FFFF (-2147418113) A system error has occurred. Error.
  • Out of memory.
오류 메시지: &H8000FFFF (-2147418113) 시스템 오류가 발생하였습니다. 오류입니다.
Error message: &H8000FFFF (-2147418113) A system error has occurred. Error.
오류 메시지: 메모리가 부족합니다.
Error message: Out of memory.

On 2022-02-19, “anonymous” reported the same error in a comment.

https://prodtool.tistory.com/23#comment8989429 (#ToDo: Review URL Changes)

오류 신고 댓글(1/2)
Error Report Comments (1/2)
오류 신고 댓글(2/2)
Error Report Comments (2/2)

At this time, the problem was not reproduced, so I couldn't find a solution. Fortunately, it was running normally on other PCs, so I didn't check it anymore.

Today, a junior employee informed me that the same error occurred, so I was able to reproduce the error while checking via remote access.

▼ How to reproduce the error

1. Right-click the Windows desktop > Display settings > Scaling and layout > Change the size of text, apps, and other items > Select 125%

텍스트, 앱 및 기타 항목의 크기 변경 125% 선택
Change the size of text, apps and other items Select 125%

2. Data standard inspection tool_v1.33 execution

3. Click the About button in the “Property Standard Check” sheet -> “&H8000FFFF (-2147418113) A system error has occurred. This is an error.” message displayed

I couldn't confirm why the scaling setting was causing the problem. We leave you with the following How to Fix Out of Memory error. This method is to change the text scaling setting to 100%, so it cannot be applied when 125% or other text scaling is required.

1. Right-click the Windows desktop > Display settings > Scaling and layout > Change the size of text, apps, and other items > Choose 100%

텍스트, 앱 및 기타 항목의 크기 변경 100% 선택
Change the size of text, apps and other items Choose 100%

2. Data standard inspection tool_v1.33 execution

3. Click the About button in the “Property Standard Check” sheet -> infallibility

Unusually, “Data Standard Check Tool_v1.33” has an error when setting the magnification to 125%, while the previous version “Attribute Name Standard Check Tool_v1.21” has no error.

I'll leave a post when I find a fundamental solution to this problem later.


This tool can be found in the github repository below.

https://github.com/DAToolset/ToolsForDataStandard

Alternatively, you can download directly from this URL.

https://github.com/DAToolset/ToolsForDataStandard/blob/main/Property standard check tool_v1.33_20210606_1.xlsm?raw=true


<< List of related articles >>

4 Responses

  1. Avatar photo ksmftp says:

    When the resolution is set as follows and the Excel macro is executed on each monitor of the laptop (125%) + secondary monitor (100%)

    CASE
    1) Execute Excel macro on laptop monitor: Error occurs
    2) Excel macro execution on the secondary monitor: normal execution
    3) Execute Excel macro on secondary monitor: Error occurs
    : In this case, it was found that the resolution of the laptop monitor was set to 100% and the Excel macro was executed normally on the secondary monitor.

    • Avatar photo Zerom says:

      I still haven't been able to figure out why the error occurs when "Size of text, apps, and other items" is not 100% and how to fix it.
      If I find it later, I will reflect it in the text or write a new article.
      Thanks for leaving a comment ^^

  2. Avatar photo 정모세 says:

    Data standard inspection tool_v1.34
    Error occurs when scaling is set to 125%
    It runs normally when the magnification is set to 100% or 150%.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_USEnglish