You aren't seeing any thing in the message dialog that gives you a clue?
One approach you may want to try is to use the Calculate Value tool to compose your SQL expression from the output of Get Field Value. Value would be a precondition to Calculate Value, which would use the expression: r"MYFIELD = '%Value%'" with the datatype set to SQL expression. The SQL expression would then connect into your Select Layer By Attribute tool.